Postgresql General Discussion
[Prev Page][Next Page]
- Re: possible license violations
- Re: arbitrary "interval" expression OK with "at time zone" but not with "set time zone" — Why?
- Re: arbitrary "interval" expression OK with "at time zone" but not with "set time zone" — Why?
- Re: syntax question
- arbitrary "interval" expression OK with "at time zone" but not with "set time zone" — Why?
- Re: BUG #17046: Upgrade postgres 11 to 13 version
- possible license violations
- LZ4 missing in pg14-beta1 Windows build, OLD VS/compiler used
- RE: BUG #17046: Upgrade postgres 11 to 13 version
- Re: syntax question
- Re: index unique
- Re: syntax question
- Re: index unique
- Re: syntax question
- index unique
- Re: syntax question
- Re: syntax question
- Re: syntax question
- Re: syntax question
- Re: max_connections
- Re: syntax question
- Re: syntax question
- Re: syntax question
- syntax question
- Re: max_connections
- Re: Dropping dependent tables
- Dropping dependent tables
- Re: Is consistent (deterministic) ordering possible in our case?
- Re: Is consistent (deterministic) ordering possible in our case?
- Re: CREATE/REFRESH MATERIALIZED VIEW planner difference?
- Re: Internationalisation (i18n) with Postgres as backend
- Re: Internationalisation (i18n) with Postgres as backend
- Re: Internationalisation (i18n) with Postgres as backend
- Re: Is consistent (deterministic) ordering possible in our case?
- Is consistent (deterministic) ordering possible in our case?
- Re: Internationalisation (i18n) with Postgres as backend
- Re: Internationalisation (i18n) with Postgres as backend
- Re: Internationalisation (i18n) with Postgres as backend
- Re: Internationalisation (i18n) with Postgres as backend
- Re: Internationalisation (i18n) with Postgres as backend
- Internationalisation (i18n) with Postgres as backend
- Re: CREATE/REFRESH MATERIALIZED VIEW planner difference?
- Re: CREATE/REFRESH MATERIALIZED VIEW planner difference?
- Re: CREATE/REFRESH MATERIALIZED VIEW planner difference?
- Re: CREATE/REFRESH MATERIALIZED VIEW planner difference?
- Re: CREATE/REFRESH MATERIALIZED VIEW planner difference?
- Re: CREATE/REFRESH MATERIALIZED VIEW planner difference?
- CREATE/REFRESH MATERIALIZED VIEW planner difference?
- Re: Query on postgres_fdw extension
- Re: Query on postgres_fdw extension
- Re: Query on postgres_fdw extension
- RE: Framework for 0 downtime deploys
- Re: WAL accumulating, Logical Replication pg 13
- Re: WAL accumulating, Logical Replication pg 13
- Re: WAL accumulating, Logical Replication pg 13
- Re: WAL accumulating, Logical Replication pg 13
- Re: WAL accumulating, Logical Replication pg 13
- max_connections
- Re: AWS forcing PG upgrade from v9.6 a disaster
- Re: Overriding natural order of query results for a subset
- Re: Overriding natural order of query results for a subset
- Re: Overriding natural order of query results for a subset
- Re: Overriding natural order of query results for a subset
- Re: Overriding natural order of query results for a subset
- Re: AWS forcing PG upgrade from v9.6 a disaster
- Re: Overriding natural order of query results for a subset
- Re: Overriding natural order of query results for a subset
- Re: WAL accumulating, Logical Replication pg 13
- Re: Overriding natural order of query results for a subset
- From: Michael van der Kolff
- Re: Overriding natural order of query results for a subset
- Overriding natural order of query results for a subset
- Re: WAL accumulating, Logical Replication pg 13
- Re: AWS forcing PG upgrade from v9.6 a disaster
- Re: AWS forcing PG upgrade from v9.6 a disaster
- From: Dean Gibson (DB Administrator)
- Re: AWS forcing PG upgrade from v9.6 a disaster
- Re: AWS forcing PG upgrade from v9.6 a disaster
- From: Dean Gibson (DB Administrator)
- Re: WAL accumulating, Logical Replication pg 13
- WAL accumulating, Logical Replication pg 13
- Re: AWS forcing PG upgrade from v9.6 a disaster
- Re: AWS forcing PG upgrade from v9.6 a disaster
- From: Dean Gibson (DB Administrator)
- Re: Modelling versioning in Postgres
- Re: How different is AWS-RDS postgres?
- Re: TRUNCATE memory leak with temporary tables?
- Re: How long to get a password reset ???
- Re: WARNING: oldest xmin is far in the past
- WARNING: oldest xmin is far in the past
- Re: TRUNCATE memory leak with temporary tables?
- Re: AWS forcing PG upgrade from v9.6 a disaster
- Re: How long to get a password reset ???
- Re: How long to get a password reset ???
- Re: TRUNCATE memory leak with temporary tables?
- Re: TRUNCATE memory leak with temporary tables?
- Re: TRUNCATE memory leak with temporary tables?
- Re: Modelling versioning in Postgres
- From: Michael van der Kolff
- Re: TRUNCATE memory leak with temporary tables?
- Re: TRUNCATE memory leak with temporary tables?
- Re: TRUNCATE memory leak with temporary tables?
- Re: TRUNCATE memory leak with temporary tables?
- Modelling versioning in Postgres
- Re: Size on disk of INT and BIGINT - not sure I'm getting it?
- Size on disk of INT and BIGINT - not sure I'm getting it?
- Re: How long to get a password reset ???
- From: Dean Gibson (DB Administrator)
- AWS forcing PG upgrade from v9.6 a disaster
- From: Dean Gibson (DB Administrator)
- TRUNCATE memory leak with temporary tables?
- Re: How different is AWS-RDS postgres?
- Re: How different is AWS-RDS postgres?
- Re: How long to get a password reset ???
- Re: How long to get a password reset ???
- How long to get a password reset ???
- From: Dean Gibson (DB Administrator)
- Re: How different is AWS-RDS postgres?
- Re: How different is AWS-RDS postgres?
- Re: How different is AWS-RDS postgres?
- Re: How different is AWS-RDS postgres?
- Re: How different is AWS-RDS postgres?
- Re: How different is AWS-RDS postgres?
- Re: How different is AWS-RDS postgres?
- Re: How different is AWS-RDS postgres?
- Re: How different is AWS-RDS postgres?
- Re: How different is AWS-RDS postgres?
- Re: How different is AWS-RDS postgres?
- Re: How different is AWS-RDS postgres?
- Re: Setting up replication
- Re: Setting up replication
- Re: How different is AWS-RDS postgres?
- Re: How different is AWS-RDS postgres?
- Re: How different is AWS-RDS postgres?
- Setting up replication
- How different is AWS-RDS postgres?
- Re: An exception about comparison operators
- An exception about comparison operators
- Re: Null database entry in pg_stat_database on pg-12 version
- Null database entry in pg_stat_database on pg-12 version
- Re: ON CONFLICT DO NOTHING ignored on bulk insert
- Re: ON CONFLICT DO NOTHING ignored on bulk insert
- Re: Simple question from a beginner: Can I use PostgreSQL as a file database?
- Re: pgadmin4 SRPM
- Re: pgadmin4 SRPM
- Re: pgadmin4 SRPM
- pgadmin4 SRPM
- Re: Simple question from a beginner: Can I use PostgreSQL as a file database?
- Simple question from a beginner: Can I use PostgreSQL as a file database?
- Re: I have no idea why pg_dump isn't dumping all of my data
- Re: ON CONFLICT DO NOTHING ignored on bulk insert
- ON CONFLICT DO NOTHING ignored on bulk insert
- Re: The contents of the pg_timezone_names view bring some surprises
- Re: array_cat in PG-14 changed signature breaks my custom aggregate
- From: Andreas Joseph Krogh
- Re: array_cat in PG-14 changed signature breaks my custom aggregate
- array_cat in PG-14 changed signature breaks my custom aggregate
- From: Andreas Joseph Krogh
- Re: The contents of the pg_timezone_names view bring some surprises
- Re: The contents of the pg_timezone_names view bring some surprises
- Re: Postgres prepare statement caching issue in postgres command line
- Re: The contents of the pg_timezone_names view bring some surprises
- Re: Postgres prepare statement caching issue in postgres command line
- Re: Proposed Chinese Translation of Community Code of Conduct
- Re: The contents of the pg_timezone_names view bring some surprises
- Re: Postgres prepare statement caching issue in postgres command line
- Re: Postgres prepare statement caching issue in postgres command line
- Re: Framework for 0 downtime deploys
- Re: Postgres prepare statement caching issue in postgres command line
- Re: Fwd: Proposed Chinese Translation of Community Code of Conduct
- Postgres prepare statement caching issue in postgres command line
- Re: The contents of the pg_timezone_names view bring some surprises
- Re: The contents of the pg_timezone_names view bring some surprises
- Re: The contents of the pg_timezone_names view bring some surprises
- Re: PG 14 - can't upgrade from a database using an aggregate with anyelement and anyarray
- Re: pgbackrest - hiding the encryption password
- Re: Fwd: Proposed Chinese Translation of Community Code of Conduct
- Re: PG 14 - can't upgrade from a database using an aggregate with anyelement and anyarray
- PG 14 - can't upgrade from a database using an aggregate with anyelement and anyarray
- Re: Framework for 0 downtime deploys
- From: Nikolay Samokhvalov
- Framework for 0 downtime deploys
- Re: pgbackrest - hiding the encryption password
- Re: The contents of the pg_timezone_names view bring some surprises
- Re: Fwd: Proposed Chinese Translation of Community Code of Conduct
- Re: The contents of the pg_timezone_names view bring some surprises
- Re: The contents of the pg_timezone_names view bring some surprises
- Re: Fwd: Proposed Chinese Translation of Community Code of Conduct
- Fwd: Proposed Chinese Translation of Community Code of Conduct
- Proposed Chinese Translation of Community Code of Conduct
- Re: The contents of the pg_timezone_names view bring some surprises
- Re: Question about integer out of range in function
- Re: Plan for exclusive backup method
- Re: I have no idea why pg_dump isn't dumping all of my data
- From: Ian Lawrence Barwick
- Re: I have no idea why pg_dump isn't dumping all of my data
- Re: I have no idea why pg_dump isn't dumping all of my data
- Re: I have no idea why pg_dump isn't dumping all of my data
- Re: I have no idea why pg_dump isn't dumping all of my data
- Re: I have no idea why pg_dump isn't dumping all of my data
- Re: I have no idea why pg_dump isn't dumping all of my data
- Re: I have no idea why pg_dump isn't dumping all of my data
- I have no idea why pg_dump isn't dumping all of my data
- Re: Any insights on Qlik Sense using CURSOR ?
- From: Franck Routier (perso)
- Re: Any insights on Qlik Sense using CURSOR ?
- From: Franck Routier (perso)
- Re: Any insights on Qlik Sense using CURSOR ?
- Re: The contents of the pg_timezone_names view bring some surprises
- Re: pgbackrest - hiding the encryption password
- Re: pgbackrest - hiding the encryption password
- Re: pgbackrest - hiding the encryption password
- Re: pgbackrest - hiding the encryption password
- Re: pgbackrest - hiding the encryption password
- Question: pgp_sym_decrypt/pgp_sym_encrypt
- Re: pgbackrest - hiding the encryption password
- Re: pgbackrest info of encrypted seems broken
- pgbackrest - hiding the encryption password
- Re: pgbackrest info of encrypted seems broken
- Re: pgbackrest info of encrypted seems broken
- 回复: [External] Re: PG 10 experience different user execute same sql get different access plan
- Re: PG 10 experience different user execute same sql get different access plan
- Re: The contents of the pg_timezone_names view bring some surprises
- Re: The contents of the pg_timezone_names view bring some surprises
- pgbackrest info of encrypted seems broken
- Re: PgAdmin4 - 'NoneType' object has no attribute 'value'
- Re: logical replication initial copy and WAL generation
- Re: logical replication initial copy and WAL generation
- logical replication initial copy and WAL generation
- Re: Plan for exclusive backup method
- PG 10 experience different user execute same sql get different access plan
- Plan for exclusive backup method
- PgAdmin4 - 'NoneType' object has no attribute 'value'
- From: Derek van den Nieuwenhuijzen
- Re: The contents of the pg_timezone_names view bring some surprises
- The contents of the pg_timezone_names view bring some surprises
- Some abbrev values from pg_timezone_names are not found in pg_timezone_abbrevs
- Re: Logical Replication: SELECT pg_catalog.set_config Statement
- Re:
- [no subject]
- Re:
- Re: unicode match normal forms
- From: goldgraeber-werbetechnik
- Re: unicode match normal forms
- From: goldgraeber-werbetechnik
- Re: Logical Replication: SELECT pg_catalog.set_config Statement
- Re: Logical Replication: SELECT pg_catalog.set_config Statement
- Any insights on Qlik Sense using CURSOR ?
- From: Franck Routier (perso)
- Re: Logical Replication: SELECT pg_catalog.set_config Statement
- Logical Replication: SELECT pg_catalog.set_config Statement
- Re: Occasional lengthy locking causing stalling on commit
- Re: unicode match normal forms
- [no subject]
- Re:
- Re:
- Re: unicode match normal forms
- Re: unicode match normal forms
- Re: unicode match normal forms
- Re: unicode match normal forms
- [no subject]
- unicode match normal forms
- Re:
- Re:
- Re:
- Re:
- Re:
- Re:
- [no subject]
- Question about integer out of range in function
- Re: Question about integer out of range in function
- Re: Postgres upgrade 12 - issues with OIDs
- Re: Empty tablespace directory after restore with psql -d dbname -f dump.sql
- Re: Postgres upgrade 12 - issues with OIDs
- Re: Postgres upgrade 12 - issues with OIDs
- Re: disabling seqscan not using primary key index?
- Re: disabling seqscan not using primary key index?
- Re: disabling seqscan not using primary key index?
- disabling seqscan not using primary key index?
- Empty tablespace directory after restore with psql -d dbname -f dump.sql
- Re: Question about integer out of range in function
- Re: RETURNING, CTEs and TRANSACTION ISOLATION levels...
- Re: Query on postgres_fdw extension
- Re: RETURNING, CTEs and TRANSACTION ISOLATION levels...
- Re: RETURNING, CTEs and TRANSACTION ISOLATION levels...
- RETURNING, CTEs and TRANSACTION ISOLATION levels...
- Re: Query on postgres_fdw extension
- Re: Query on postgres_fdw extension
- Re: Query on postgres_fdw extension
- Re: Query on postgres_fdw extension
- Re: Same column names in a subresult table
- Re: Question about integer out of range in function
- Re: Same column names in a subresult table
- From: Rory Campbell-Lange
- Same column names in a subresult table
- Re: Query on postgres_fdw extension
- Re: Question about integer out of range in function
- Re: Query on postgres_fdw extension
- Question about integer out of range in function
- Re: [RPM/CentOS7] Need to disable repo_gpgcheck on pgdg-common when using RPM version 42.0-17.1
- Re: [RPM/CentOS7] Need to disable repo_gpgcheck on pgdg-common when using RPM version 42.0-17.1
- Postgresql fdw tracing
- Re: [RPM/CentOS7] Need to disable repo_gpgcheck on pgdg-common when using RPM version 42.0-17.1
- Re: ERROR: no known snapshots
- Re: ERROR: no known snapshots
- Re: force partition pruning
- Re: ERROR: no known snapshots
- SV: force partition pruning
- Re: force partition pruning
- ERROR: no known snapshots
- Re: force partition pruning
- Re: force partition pruning
- Re: force partition pruning
- Re: Sequence gaps after restart
- Re: Sequence gaps after restart
- Re: Sequence gaps after restart
- Sequence gaps after restart
- SV: force partition pruning
- Re: force partition pruning
- Re: Postgresql 13 query engine regression
- Re: Postgresql 13 query engine regression
- Re: Postgresql 13 query engine regression
- Re: Postgresql 13 query engine regression
- Re: Postgresql 13 query engine regression
- Re: Postgresql 13 query engine regression
- Re: Postgresql 13 query engine regression
- Re: Postgresql 13 query engine regression
- Postgresql 13 query engine regression
- Re: trigger impacting insertion of records
- Re: Copyright vs Licence
- Re: force partition pruning
- Re: Copyright vs Licence
- force partition pruning
- Re: Copyright vs Licence
- Copyright vs Licence
- Re: Issue in PG start
- Re: Postgres upgrade 12 - issues with OIDs
- Re: Setting wal_keep_segments parameter
- Setting wal_keep_segments parameter
- Re: Issue in PG start
- Re: Issue in PG start
- Re: Issue in PG start
- From: sivapostgres@xxxxxxxxx
- Re: Issue in PG start
- From: sivapostgres@xxxxxxxxx
- Re: Metric to calculate WAL size left to transfer to Standby
- Re: idle_in_transaction_session_timeout
- Re: Issue in PG start
- Re: Issue in PG start
- Re: Issue in PG start
- Re: Issue in PG start
- Re: idle_in_transaction_session_timeout
- Re: Issue in PG start
- From: sivapostgres@xxxxxxxxx
- Re: idle_in_transaction_session_timeout
- Re: idle_in_transaction_session_timeout
- Re: pg_upgrade and wraparound
- Re: Issue in PG start
- From: sivapostgres@xxxxxxxxx
- Re: Issue in PG start
- Re: Issue in PG start
- From: sivapostgres@xxxxxxxxx
- Re: Postgres upgrade 12 - issues with OIDs
- Re: Postgres upgrade 12 - issues with OIDs
- Re: trigger impacting insertion of records
- Re: Strange behavior of function date_trunc
- Re: Strange behavior of function date_trunc
- Re: [RPM/CentOS7] Need to disable repo_gpgcheck on pgdg-common when using RPM version 42.0-17.1
- Re: Optimizing search query with sorting by creation field
- Re: [RPM/CentOS7] Need to disable repo_gpgcheck on pgdg-common when using RPM version 42.0-17.1
- Re: idle_in_transaction_session_timeout
- SV: idle_in_transaction_session_timeout
- Re: trigger impacting insertion of records
- idle_in_transaction_session_timeout
- Optimizing search query with sorting by creation field
- Re: "invalid contrecord" error on replica
- Re: Strange behavior of function date_trunc
- Re: Strange behavior of function date_trunc
- Re: trigger impacting insertion of records
- Compiling a ossp-uuid module for Win32
- [RPM/CentOS7] Need to disable repo_gpgcheck on pgdg-common when using RPM version 42.0-17.1
- Re: Strange behavior of function date_trunc
- Re: Strange behavior of function date_trunc
- Re: Chain Hashing
- Re: Strange behavior of function date_trunc
- Re: trigger impacting insertion of records
- Re: Trusty postgresql-client-9.5_9.5.17-1.pgdg14.04+1_amd64.deb removed ?
- Re: Trusty postgresql-client-9.5_9.5.17-1.pgdg14.04+1_amd64.deb removed ?
- Chain Hashing
- trigger impacting insertion of records
- Re: "invalid contrecord" error on replica
- Re: Trusty postgresql-client-9.5_9.5.17-1.pgdg14.04+1_amd64.deb removed ?
- Re: Trusty postgresql-client-9.5_9.5.17-1.pgdg14.04+1_amd64.deb removed ?
- Trusty postgresql-client-9.5_9.5.17-1.pgdg14.04+1_amd64.deb removed ?
- Re: Strange behavior of function date_trunc
- Postgresql post_parse_analyze_hook not getting triggered for COMMIT command
- Re: Strange behavior of function date_trunc
- Re: Strange behavior of function date_trunc
- Re: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616"
- Re: Strange behavior of function date_trunc
- Strange behavior of function date_trunc
- Re: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616"
- From: Arne Henrik Segtnan
- Re: Error creating postgres extensions
- Re: Huge performance penalty with parallel queries in Windows x64 v. Linux x64
- Re: Huge performance penalty with parallel queries in Windows x64 v. Linux x64
- Re: Error creating postgres extensions
- From: Ian Lawrence Barwick
- Error creating postgres extensions
- Re: Postgres upgrade 12 - issues with OIDs
- Postgres upgrade 12 - issues with OIDs
- Re: Extended stats - value not in MCV list
- Re: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616"
- Re: AW: Huge performance penalty with parallel queries in Windows x64 v. Linux x64
- Re: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616"
- Re: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616"
- Re: PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616"
- AW: Huge performance penalty with parallel queries in Windows x64 v. Linux x64
- PostgreSQL upgrade from 10 to 12 fails with "ERROR: column r.relhasoids does not exist at character 1616"
- From: Arne Henrik Segtnan
- Re: Huge performance penalty with parallel queries in Windows x64 v. Linux x64
- Re: Is this the future of I/O for the RDBMS?
- Re: PostgreSQL, Asynchronous I/O, Buffered I/O and why did fsync-gate not affect Oracle or MySQL?
- Re: PostgreSQL, Asynchronous I/O, Buffered I/O and why did fsync-gate not affect Oracle or MySQL?
- Re: PostgreSQL, Asynchronous I/O, Buffered I/O and why did fsync-gate not affect Oracle or MySQL?
- AW: Huge performance penalty with parallel queries in Windows x64 v. Linux x64
- Identified cause of potential pg_upgrade failure on Windows due to OS update adding partial block list of ports 50xxxx (could not connect to server)
- Re: Huge performance penalty with parallel queries in Windows x64 v. Linux x64
- Huge performance penalty with parallel queries in Windows x64 v. Linux x64
- Re: pg_upgrade and wraparound
- Re: "invalid contrecord" error on replica
- Re: Access a newer Version of PGDB (v13) with an older libpq (v10 x86)
- Re: "invalid contrecord" error on replica
- Re: "invalid contrecord" error on replica
- Re: Access a newer Version of PGDB (v13) with an older libpq (v10 x86)
- Re: Access a newer Version of PGDB (v13) with an older libpq (v10 x86)
- Re: "invalid contrecord" error on replica
- Re: Is this the future of I/O for the RDBMS?
- Re: PostgreSQL, Asynchronous I/O, Buffered I/O and why did fsync-gate not affect Oracle or MySQL?
- Re: PostgreSQL, Asynchronous I/O, Buffered I/O and why did fsync-gate not affect Oracle or MySQL?
- Re: PostgreSQL, Asynchronous I/O, Buffered I/O and why did fsync-gate not affect Oracle or MySQL?
- Is this the future of I/O for the RDBMS?
- PostgreSQL, Asynchronous I/O, Buffered I/O and why did fsync-gate not affect Oracle or MySQL?
- Re: Why is writing JSONB faster than just JSON?
- Extended stats - value not in MCV list
- From: Pedro Luis Guzmán Hernández
- Re: Access a newer Version of PGDB (v13) with an older libpq (v10 x86)
- Re: Access a newer Version of PGDB (v13) with an older libpq (v10 x86)
- Re: -1/0 virtualtransaction
- Re: database sorting algorithms.
- Re: database sorting algorithms.
- Re: database sorting algorithms.
- database sorting algorithms.
- Re: Access a newer Version of PGDB (v13) with an older libpq (v10 x86)
- Re: Access a newer Version of PGDB (v13) with an older libpq (v10 x86)
- Re: -1/0 virtualtransaction
- Re: pg_upgrade and wraparound
- Re: "Skipping" BitmapHeapScan for simple counts
- Re: Access a newer Version of PGDB (v13) with an older libpq (v10 x86)
- Re: -1/0 virtualtransaction
- Re: Streaming replica failure
- Re: Access a newer Version of PGDB (v13) with an older libpq (v10 x86)
- Access a newer Version of PGDB (v13) with an older libpq (v10 x86)
- "Skipping" BitmapHeapScan for simple counts
- Re: Oracle vs. PostgreSQL - a comment
- Re: client backwards compatible with older servers
- client backwards compatible with older servers
- Re: index only scan taking longer to run
- Re: index only scan taking longer to run
- Re: Oracle vs. PostgreSQL - a comment
- Re: Oracle vs. PostgreSQL - a comment
- index only scan taking longer to run
- Re: Open source licenses
- RE: Open source licenses
- Re: postgres index usage count too high
- postgres index usage count too high
- Re: pgbouncer configuration
- Re: pgbouncer configuration
- Re: Oracle vs. PostgreSQL - a comment
- Re: pgbouncer configuration
- Re: very long secondary->primary switch time
- pgbouncer configuration
- Re: very long secondary->primary switch time
- Re: -1/0 virtualtransaction
- very long secondary->primary switch time
- Re: Approach to creating users in Database
- Re: -1/0 virtualtransaction
- Re: DB size
- Approach to creating users in Database
- Streaming replica failure
- Re: Temporary files usage in explain
- Re: Temporary files usage in explain
- Re: Temporary files usage in explain
- Temporary files usage in explain
- Re: About to know the info of foreign table reference used in any of call ,views,functions
- From: Charles Clavadetscher
- About to know the info of foreign table reference used in any of call ,views,functions
- Re: DB size
- Re: DB size
- Re: DB size
- Re: -1/0 virtualtransaction
- About to find all foreign tables are being used by sproc and view and function
- Re: -1/0 virtualtransaction
- Re: -1/0 virtualtransaction
- -1/0 virtualtransaction
- Re: DB size
- Re: DB size
- Re: DB size
- Re: DB size
- DB size
- Re: Invalid byte sequence when importing Oracle BLOB
- Re: Invalid byte sequence when importing Oracle BLOB
- Re: impact of version upgrade on fts
- Re: Invalid byte sequence when importing Oracle BLOB
- Re: Invalid byte sequence when importing Oracle BLOB
- Re: Invalid byte sequence when importing Oracle BLOB
- Re: Invalid byte sequence when importing Oracle BLOB
- Re: BRIN index on timestamptz
- Re: BRIN index on timestamptz
- From: Mohan Radhakrishnan
- Invalid byte sequence when importing Oracle BLOB
- Re: client waits for end of update operation and server proc is idle
- Re: client waits for end of update operation and server proc is idle
- Re: client waits for end of update operation and server proc is idle
- Re: impact of version upgrade on fts
- Re: client waits for end of update operation and server proc is idle
- Re: client waits for end of update operation and server proc is idle
- Re: client waits for end of update operation and server proc is idle
- Re: client waits for end of update operation and server proc is idle
- Re: client waits for end of update operation and server proc is idle
- Re: client waits for end of update operation and server proc is idle
- Re: impact of version upgrade on fts
- impact of version upgrade on fts
- Re: client waits for end of update operation and server proc is idle
- Re: BRIN index on timestamptz
- From: Mohan Radhakrishnan
- Re: BRIN index on timestamptz
- Re: enable_seqscan to off -> initial cost 10000000000
- Re: BRIN index on timestamptz
- Re: BRIN index on timestamptz
- From: Mohan Radhakrishnan
- Re: BRIN index on timestamptz
- Re: server process exited with code 1
- Re: server process exited with code 1
- Re: server process exited with code 1
- Re: Why is writing JSONB faster than just JSON?
- Re: Why is writing JSONB faster than just JSON?
- Re: Why is writing JSONB faster than just JSON?
- Re: Why is writing JSONB faster than just JSON?
- Re: server process exited with code 1
- Re: server process exited with code 1
- server process exited with code 1
- Re: enable_seqscan to off -> initial cost 10000000000
- Re: enable_seqscan to off -> initial cost 10000000000
- enable_seqscan to off -> initial cost 10000000000
- Re: client waits for end of update operation and server proc is idle
- Re: Why is writing JSONB faster than just JSON?
- Re: client waits for end of update operation and server proc is idle
- Re: client waits for end of update operation and server proc is idle
- BRIN index on timestamptz
- From: Mohan Radhakrishnan
- client waits for end of update operation and server proc is idle
- Re: Oracle vs. PostgreSQL - a comment
- Re: Oracle vs. PostgreSQL - a comment
- finding and monitoring old WAL archives
- Alter generated column expression
- Re: archive_commnad parameter question
- Re: archive_commnad parameter question
- Re: archive_commnad parameter question
- Re: archive_commnad parameter question
- archive_commnad parameter question
- RE: could not read from hash-join temporary file: SUCCESS && DB goes into recovery mode
- RE: could not read from hash-join temporary file: SUCCESS && DB goes into recovery mode
- Re: could not read from hash-join temporary file: SUCCESS && DB goes into recovery mode
- RE: could not read from hash-join temporary file: SUCCESS && DB goes into recovery mode
- Re: Storing state machine
- From: Mohan Radhakrishnan
- Re: could not read from hash-join temporary file: SUCCESS && DB goes into recovery mode
- Re: postgres in container, redirect csvlog to stderr
- Re: could not read from hash-join temporary file: SUCCESS && DB goes into recovery mode
- Re: Question about contrib
- postgres in container, redirect csvlog to stderr
- From: Filip Rembiałkowski
- Re: Storing state machine
- From: Mohan Radhakrishnan
- could not read from hash-join temporary file: SUCCESS && DB goes into recovery mode
- Re: Question about contrib
- Re: Question about contrib
- Re: Question about contrib
- Re: Question about contrib
- Question about contrib
- Re: Storing state machine
- Storing state machine
- From: Mohan Radhakrishnan
- Re: Vulnerability PostgreSQL 11.2
- Planning time grows exponentially with levels of nested views
- Re: Metric to calculate WAL size left to transfer to Standby
- Re: Vulnerability PostgreSQL 11.2
- From: Moris Rumenov Vrachovski
- Re: Size of PostgreSQL backup ./. Sybase DUMP
- Re: Size of PostgreSQL backup ./. Sybase DUMP
- Re: Vulnerability PostgreSQL 11.2
- Re: vaccumdb fails saying function unaccent(text) doesn't exist
- vaccumdb fails saying function unaccent(text) doesn't exist
- Re: Size of PostgreSQL backup ./. Sybase DUMP
- Re: Size of PostgreSQL backup ./. Sybase DUMP
- Size of PostgreSQL backup ./. Sybase DUMP
- Re: Question about PG_CONTROL_VERSION 1
- Re: Query processing in postgresql
- SV: where clauses including timstamptz and intervals
- Re: Query processing in postgresql
- Re: Pg_upgrade problem.
- Re: Timestamp/hstore query?
- Re: Pg_upgrade problem.
- Re: Pg_upgrade problem.
- Re: Why is writing JSONB faster than just JSON?
- Re: Pg_upgrade problem.
- Re: Pg_upgrade problem.
- Re: Pg_upgrade problem.
- Re: Pg_upgrade problem.
- Re: Pg_upgrade problem.
- Re: Query processing in postgresql
- Query processing in postgresql
- Re: Why is writing JSONB faster than just JSON?
- Pg_upgrade problem.
- Re: Why is writing JSONB faster than just JSON?
- Re: Timestamp/hstore query?
- Re: Metric to calculate WAL size left to transfer to Standby
- Re: Vulnerability PostgreSQL 11.2
- Re: Vulnerability PostgreSQL 11.2
- Vulnerability PostgreSQL 11.2
- From: Moris Rumenov Vrachovski
- Metric to calculate WAL size left to transfer to Standby
- Re: Suboptimal plan when IN(...), ORDER BY and LIMIT are used (no JOINs)
- Re: Suboptimal plan when IN(...), ORDER BY and LIMIT are used (no JOINs)
- Re: Timestamp/hstore query?
- Re: Timestamp/hstore query?
- Timestamp/hstore query?
- Re: Question about PG_CONTROL_VERSION 1
- Question about PG_CONTROL_VERSION 1
- Re: Why is writing JSONB faster than just JSON?
- View invoker privileges
- Re: Why is writing JSONB faster than just JSON?
- Why is writing JSONB faster than just JSON?
- RE: [Extern] Re: Advice on binary installation
- RE: Ways to "serialize" result set for later use?
- Suboptimal plan when IN(...), ORDER BY and LIMIT are used (no JOINs)
- RE: looking for a installation package to Using GSSAPI with Postgres12 for windows
- From: LE MENTEC, SANDRINE
- Re: "missing chunk number 0 for toast value xxx in pg_toast_xxx" when pg_basebackup
- Re: "missing chunk number 0 for toast value xxx in pg_toast_xxx" when pg_basebackup
- Re: looking for a installation package to Using GSSAPI with Postgres12 for windows
- From: Jehan-Guillaume de Rorthais
- Re: "missing chunk number 0 for toast value xxx in pg_toast_xxx" when pg_basebackup
- AW: [Extern] Re: Advice on binary installation
- From: Zwettler Markus (OIZ)
- Re: Advice on binary installation
- Advice on binary installation
- From: Zwettler Markus (OIZ)
- Re: "missing chunk number 0 for toast value xxx in pg_toast_xxx" when pg_basebackup
- Re: rollback previous commit if the current one fails
- Re: rollback previous commit if the current one fails
- "missing chunk number 0 for toast value xxx in pg_toast_xxx" when pg_basebackup
- looking for a installation package to Using GSSAPI with Postgres12 for windows
- From: LE MENTEC, SANDRINE
- rollback previous commit if the current one fails
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- Re: How can I insert the image as a blob in the table
- Re: How can I insert the image as a blob in the table
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- Re: How can I insert the image as a blob in the table
- Re: How can I insert the image as a blob in the table
- Re: How can I insert the image as a blob in the table
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- Re: Prepare Statement VS Literal Values
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- Re: Reuse of REF Cursor
- Re: Ways to "serialize" result set for later use?
- RE: Ways to "serialize" result set for later use?
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- Re: How can I insert the image as a blob in the table
- Re: How can I insert the image as a blob in the table
- Re: How can I insert the image as a blob in the table
- Re: How can I insert the image as a blob in the table
- Re: Prepare Statement VS Literal Values
- Re: How can I insert the image as a blob in the table
- Prepare Statement VS Literal Values
- RE: Re: Reuse of REF Cursor
- How can I insert the image as a blob in the table
- Re: Reuse of REF Cursor
- RE: Re: Reuse of REF Cursor
- Re: Reuse of REF Cursor
- RE: Re: Reuse of REF Cursor
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- Re: Reuse of REF Cursor
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- Re: Reuse of REF Cursor
- Re: Who altered the database?
- Reuse of REF Cursor
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- Ways to "serialize" result set for later use?
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- Re: The Amazon CloudFront distribution is configured to block access from your country.
- The Amazon CloudFront distribution is configured to block access from your country.
- Re: where clauses including timstamptz and intervals
- Re: Multiple LDAP Servers for ldap Authentication
- issue during installation of postgresql binary zip
- SV: where clauses including timstamptz and intervals
- Re: where clauses including timstamptz and intervals
- Re: Who altered the database?
- Re: where clauses including timstamptz and intervals
- Re: Who altered the database?
- Re: where clauses including timstamptz and intervals
- Re: Is replacing transactions with CTE a good idea?
- Re: Is replacing transactions with CTE a good idea?
- Who altered the database?
- Re: where clauses including timstamptz and intervals
- From: hubert depesz lubaczewski
- Re: ERROR : invalid transaction termination : PostgreSQL v12
- where clauses including timstamptz and intervals
- "index contains unexpected zero page" problem
- Re: Check constraint failure messages
- RE: Check constraint failure messages
- Re: Primary keys and composite unique keys(basic question)
- Re: Cascade publication with pg_stat_replication empty
- Re: Cascade publication with pg_stat_replication empty
- Re: could not receive data from client: Connection reset by peer
- could not receive data from client: Connection reset by peer
- Re: Primary keys and composite unique keys(basic question)
- Re: Primary keys and composite unique keys(basic question)
- Re: Primary keys and composite unique keys(basic question)
- Re: Primary keys and composite unique keys(basic question)
- Re: Primary keys and composite unique keys(basic question)
- Re: PostgreSQL log query's result size
- PostgreSQL log query's result size
- Re: Using indexes through a plpgsql procedure
- Re: Cascade publication with pg_stat_replication empty
- Cascade publication with pg_stat_replication empty
- Using indexes through a plpgsql procedure
- RE: Upgrade from 11.3 to 13.1 failed with out of memory
- RE: Open source licenses
- Re: Open source licenses
- Re: Check constraint failure messages
- Re: Check constraint failure messages
- Re: Check constraint failure messages
- Re: Check constraint failure messages
- Check constraint failure messages
- Re: MultiXactId wraparound and last aggressive vacuum time
- From: Jehan-Guillaume de Rorthais
- Re: LDAP, single sign on from Windows client
- Re: questions about wraparound
- From: Jehan-Guillaume de Rorthais
- Re: Open source licenses
- RE: Open source licenses
- Re: Upgrade from 11.3 to 13.1 failed with out of memory
- Upgrade from 11.3 to 13.1 failed with out of memory
- Re: MultiXactId wraparound and last aggressive vacuum time
- LDAP, single sign on from Windows client
- Re: questions about wraparound
- Re: Primary keys and composite unique keys(basic question)
- Re: Primary keys and composite unique keys(basic question)
- Re: Primary keys and composite unique keys(basic question)
- Re: Debugging leaking memory in Postgresql 13.2/Postgis 3.1
- Re: Primary keys and composite unique keys(basic question)
- Re: Is replacing transactions with CTE a good idea?
- Re: Is replacing transactions with CTE a good idea?
- Re: Is replacing transactions with CTE a good idea?
- Re: How to deny access to Postgres when connected from host/non-local
- Re: Debugging leaking memory in Postgresql 13.2/Postgis 3.1
- Re: Is replacing transactions with CTE a good idea?
- Re: Is replacing transactions with CTE a good idea?
- Re: Is replacing transactions with CTE a good idea?
- Re: Slick way to update multiple tables.
- Re: Is replacing transactions with CTE a good idea?
- Re: Upgrading from 11 to 13
- Re: Upgrading from 11 to 13
- Re: Upgrading from 11 to 13
- What is the expected difference in performance between querying a all partitions of a partitioned table and non partitioned one?
- Re: Upgrading from 11 to 13
- Re: = t1 - t0 but t0 + i <> t1 when t1 and t2 timestamptz values and i is an interval value
- Re: Upgrading from 11 to 13
- Re: Debugging leaking memory in Postgresql 13.2/Postgis 3.1
- Re: How to deny access to Postgres when connected from host/non-local
- How to deny access to Postgres when connected from host/non-local
- Re: Upgrading from 11 to 13
- Re: ignore tablespace in schema definition queries
- From: Joao Miguel Ferreira
- Re: ignore tablespace in schema definition queries
- Re: questions about wraparound
- Re: ignore tablespace in schema definition queries
- ignore tablespace in schema definition queries
- From: Joao Miguel Ferreira
- Fwd: Proposed Italian Translation of Code of Conduct Policy
- Re: How to install PostgreSQL binaries on a different directory than the default one
- Re: How to install PostgreSQL binaries on a different directory than the default one
- Re: Have I found an interval arithmetic bug?
- Re: Have I found an interval arithmetic bug?
- How to install PostgreSQL binaries on a different directory than the default one
- Re: Have I found an interval arithmetic bug?
- Re: Have I found an interval arithmetic bug?
- Re: How to implement expiration in PostgreSQL?
- Re: pass non-formated query to PL function
- From: Joao Miguel Ferreira
- Have I found an interval arithmetic bug?
- Re: pass non-formated query to PL function
- Re: pass non-formated query to PL function
- pass non-formated query to PL function
- From: Joao Miguel Ferreira
- Re: Primary keys and composite unique keys(basic question)
- Re: questions about wraparound
- From: Jehan-Guillaume de Rorthais
- Re: Primary keys and composite unique keys(basic question)
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[PHP Home]
[PHP on Windows]
[Yosemite]