Postgresql General Discussion

• Thread Index

• Re: [HACKERS] function for setting/getting same timestamp during whole transaction
  • From: Miroslav Šimulčík
• REINDEX deadlock - Postgresql -9.1
  • From: Anoop K
• Re: Hot Standby has PANIC: WAL contains references to invalid pages
  • From: amutu
• Re: Hot Standby has PANIC: WAL contains references to invalid pages
  • From: Michael Harris
• Re: [HACKERS] function for setting/getting same timestamp during whole transaction
  • From: Gurjeet Singh
• Re: configuring timezone
  • From: Igor Neyman
• Re: configuring timezone
  • From: Terence Ferraro
• Re: configuring timezone
  • From: Tom Lane
• Re: configuring timezone
  • From: Adrian Klaver
• Re: configuring timezone
  • From: Igor Neyman
• Re: configuring timezone
  • From: Adrian Klaver
• Re: configuring timezone
  • From: Igor Neyman
• Re: configuring timezone
  • From: Terence Ferraro
• Re: Keeping historical record changes w/ triggers - best practices?
  • From: Jeff Janes
• Re: DEFERRABLE NOT NULL constraint
  • From: Gavan Schneider
• Re: Keeping historical record changes w/ triggers - best practices?
  • From: Wells Oliver
• Re: Keeping historical record changes w/ triggers - best practices?
  • From: Greg Donald
• Re: configuring timezone
  • From: Igor Neyman
• Re: configuring timezone
  • From: Terence Ferraro
• Keeping historical record changes w/ triggers - best practices?
  • From: Wells Oliver
• configuring timezone
  • From: Igor Neyman
• Re: best config
  • From: Steven Schlansker
• Re: best config
  • From: Roberto Scattini
• Re: best config
  • From: Steven Schlansker
• best config
  • From: Roberto Scattini
• Re: ERROR: invalid input syntax for integer: ""
  • From: Tom Lane
• Re: ERROR: invalid input syntax for integer: ""
  • From: Adrian Klaver
• Re: Passing dynamic parameters to a table-returning function
  • From: Moshe Jacobson
• Re: DEFERRABLE NOT NULL constraint
  • From: Alban Hertroys
• Re: Need help understanding WAL and checkpoints
  • From: Albe Laurenz
• Re: DEFERRABLE NOT NULL constraint
  • From: Chris Angelico
• Re: DEFERRABLE NOT NULL constraint
  • From: Bèrto ëd Sèra
• Need help understanding WAL and checkpoints
  • From: drew_hunt1976
• Re: "explain analyze" a procedure verbosely - to find which statement in it takes longer
  • From: Alban Hertroys
• Re: "explain analyze" a procedure verbosely - to find which statement in it takes longer
  • From: Pavel Stehule
• "explain analyze" a procedure verbosely - to find which statement in it takes longer
  • From: Alexander Farber
• Re: ERROR: invalid input syntax for integer: ""
  • From: Ben Madin
• Re: DEFERRABLE NOT NULL constraint
  • From: Chris Angelico
• Re: DEFERRABLE NOT NULL constraint
  • From: Jasen Betts
• Re: DEFERRABLE NOT NULL constraint
  • From: Bèrto ëd Sèra
• Re: ERROR: invalid input syntax for integer: ""
  • From: Ben Madin
• Re: ERROR: invalid input syntax for integer: ""
  • From: Tom Lane
• Re: ERROR: invalid input syntax for integer: ""
  • From: Adrian Klaver
• Re: ERROR: invalid input syntax for integer: ""
  • From: Adrian Klaver
• Re: DEFERRABLE NOT NULL constraint
  • From: Jasen Betts
• Re: ERROR: invalid input syntax for integer: ""
  • From: Ben Madin
• Re: ERROR: invalid input syntax for integer: ""
  • From: Adrian Klaver
• Re: .pgpass and root: a problem
  • From: Jasen Betts
• Re: ERROR: invalid input syntax for integer: "" - more confusion
  • From: Ben Madin
• Re: ERROR: invalid input syntax for integer: ""
  • From: Adrian Klaver
• Re: ERROR: invalid input syntax for integer: ""
  • From: Ben Madin
• Re: ERROR: invalid input syntax for integer: "" - more confusion
  • From: Adrian Klaver
• Re: ERROR: invalid input syntax for integer: ""
  • From: Adrian Klaver
• ERROR: invalid input syntax for integer: "" - more confusion
  • From: Ben Madin
• ERROR: invalid input syntax for integer: ""
  • From: Ben Madin
• cleanup of pgsql_tmp directory
  • From: ROBERT KLAUS
• Re: Passing dynamic parameters to a table-returning function
  • From: David Johnston
• SP-GiST indexing for box types?
  • From: aasat
• Re: .pgpass and root: a problem
  • From: Stephen Frost
• Re: .pgpass and root: a problem
  • From: Shaun Thomas
• Re: .pgpass and root: a problem
  • From: Stephen Frost
• Re: .pgpass and root: a problem
  • From: Shaun Thomas
• Re: .pgpass and root: a problem
  • From: Scott Marlowe
• Re: .pgpass and root: a problem
  • From: Stephen Frost
• Re: .pgpass and root: a problem
  • From: Michael Nolan
• Re: .pgpass and root: a problem
  • From: Shaun Thomas
• Re: .pgpass and root: a problem
  • From: Scott Marlowe
• Re: .pgpass and root: a problem
  • From: Scott Mead
• Re: .pgpass and root: a problem
  • From: Joshua D. Drake
• Re: .pgpass and root: a problem
  • From: Scott Marlowe
• Re: cleanup of pgsql_tmp directory
  • From: Robert Klaus
• Re: cleanup of pgsql_tmp directory
  • From: Tom Lane
• Re: Passing dynamic parameters to a table-returning function
  • From: Moshe Jacobson
• .pgpass and root: a problem
  • From: Shaun Thomas
• Re: [BUGS] BUG #7850: left outer join is not working or I didn't contruct the query properly
  • From: Alban Hertroys
• Re: [BUGS] BUG #7850: left outer join is not working or I didn't contruct the query properly
  • From: Amit Kapila
• cleanup of pgsql_tmp directory
  • From: Robert Klaus
• Re: tablespace directories
  • From: Bèrto ëd Sèra
• Re: tablespace directories
  • From: Albe Laurenz
• Re: DEFERRABLE NOT NULL constraint
  • From: Alban Hertroys
• Re: DEFERRABLE NOT NULL constraint
  • From: Andreas Joseph Krogh
• Re: COPY table to file missing quotation marks
  • From: Vick Khera
• Re: Passing dynamic parameters to a table-returning function
  • From: Amit Kapila
• Re: DEFERRABLE NOT NULL constraint
  • From: Bèrto ëd Sèra
• Re: DEFERRABLE NOT NULL constraint
  • From: Albe Laurenz
• Re: tablespace directories
  • From: Bèrto ëd Sèra
• tablespace directories
  • From: Bèrto ëd Sèra
• Re: DEFERRABLE NOT NULL constraint
  • From: Bèrto ëd Sèra
• Re: DEFERRABLE NOT NULL constraint
  • From: Chris Angelico
• Re: DEFERRABLE NOT NULL constraint
  • From: Bèrto ëd Sèra
• Re: DEFERRABLE NOT NULL constraint
  • From: Chris Angelico
• Re: DEFERRABLE NOT NULL constraint
  • From: Bèrto ëd Sèra
• Re: DEFERRABLE NOT NULL constraint
  • From: Andreas Joseph Krogh
• Re: DEFERRABLE NOT NULL constraint
  • From: Alban Hertroys
• Re: DEFERRABLE NOT NULL constraint
  • From: Andreas Joseph Krogh
• Re: COPY FROM on Windows and accentuated characters in the file path
  • From: Raghavendra
• Re: COPY FROM on Windows and accentuated characters in the file path
  • From: Bruce Momjian
• Re: Hot Standby has PANIC: WAL contains references to invalid pages
  • From: Hari Babu
• Re: DEFERRABLE NOT NULL constraint
  • From: Thomas Kellerer
• Re: DEFERRABLE NOT NULL constraint
  • From: Alban Hertroys
• COPY FROM on Windows and accentuated characters in the file path
  • From: Thierry Hauchard
• Re: DEFERRABLE NOT NULL constraint
  • From: Andreas Joseph Krogh
• Re: DEFERRABLE NOT NULL constraint
  • From: Виктор Егоров
• Re: DEFERRABLE NOT NULL constraint
  • From: Thomas Kellerer
• Re: DEFERRABLE NOT NULL constraint
  • From: Andreas Joseph Krogh
• Re: DEFERRABLE NOT NULL constraint
  • From: Darren Duncan
• Re: partial time stamp query
  • From: Misa Simic
• Re: DEFERRABLE NOT NULL constraint
  • From: Andreas Joseph Krogh
• Re: DEFERRABLE NOT NULL constraint
  • From: Albe Laurenz
• Re: What language is faster, C or PL/PgSQL?
  • From: Pavel Stehule
• Re: What language is faster, C or PL/PgSQL?
  • From: Carlo Stonebanks
• Re: What language is faster, C or PL/PgSQL?
  • From: Bruce Momjian
• Re: partial time stamp query
  • From: Kirk Wythers
• Re: partial time stamp query
  • From: Moshe Jacobson
• Re: partial time stamp query
  • From: Misa Simic
• Re: Reverse Engr into erwin
  • From: Edson Richter
• Hot Standby has PANIC: WAL contains references to invalid pages
  • From: Michael Harris
• Re: partial time stamp query
  • From: Brent Wood
• Reverse Engr into erwin
  • From: Little, Douglas
• Re: PGAdmin on Windows (yeah, i know!!) and registry/.ini questions
  • From: Carlo Stonebanks
• Re: date_trunc to aggregate values?
  • From: Kirk Wythers
• Re: date_trunc to aggregate values?
  • From: Jason Dusek
• Re: PGAdmin on Windows (yeah, i know!!) and registry/.ini questions
  • From: John R Pierce
• PGAdmin on Windows (yeah, i know!!) and registry/.ini questions
  • From: David Wooffindin
• Re: Options for passing values to triggers?
  • From: Gurjeet Singh
• Aggregating inet subnets to supernets
  • From: Sven Ulland
• Passing dynamic parameters to a table-returning function
  • From: Moshe Jacobson
• Re: partial time stamp query
  • From: Kirk Wythers
• Re: Is it possible to migrate database from Postgresql 8.2 to 9.2 using pg_upgrade?
  • From: Steve Crawford
• Is it possible to migrate database from Postgresql 8.2 to 9.2 using pg_upgrade?
  • From: AI Rumman
• Re: Adding PRIMARY KEY: Table contains duplicated values
  • From: Andreas Kretschmer
• Re: Options for passing values to triggers?
  • From: Pavel Stehule
• Options for passing values to triggers?
  • From: org.postgresql
• DEFERRABLE NOT NULL constraint
  • From: Andreas Joseph Krogh
• Re: Adding PRIMARY KEY: Table contains duplicated values
  • From: Alexander Farber
• date_trunc to aggregate values?
  • From: Kirk Wythers
• Fwd: partial time stamp query
  • From: Kirk Wythers
• Re: partial time stamp query
  • From: Kirk Wythers
• Re: Adding PRIMARY KEY: Table contains duplicated values
  • From: Andreas Kretschmer
• Re: Adding PRIMARY KEY: Table contains duplicated values
  • From: Andreas Kretschmer
• Re: Diferences between IN and EXISTS?
  • From: Edson Richter
• Re: Diferences between IN and EXISTS?
  • From: zeljko
• Re: Adding PRIMARY KEY: Table contains duplicated values
  • From: Adrian Klaver
• Re: Adding PRIMARY KEY: Table contains duplicated values
  • From: Alexander Farber
• Re: Adding PRIMARY KEY: Table contains duplicated values
  • From: Adrian Klaver
• Re: partial time stamp query
  • From: Misa Simic
• partial time stamp query
  • From: Kirk Wythers
• Re: Adding PRIMARY KEY: Table contains duplicated values
  • From: Alexander Farber
• partial time stamp query
  • From: Kirk Wythers
• Re: [JDBC] JDBC connection test with SSL on PG 9.2.1 server
  • From: Adrian Klaver
• Re: Adding PRIMARY KEY: Table contains duplicated values
  • From: Alexander Farber
• Re: What language is faster, C or PL/PgSQL?
  • From: Merlin Moncure
• Re: Adding PRIMARY KEY: Table contains duplicated values
  • From: Adrian Klaver
• Adding PRIMARY KEY: Table contains duplicated values
  • From: Alexander Farber
• Re: WARNING: pgstat wait timeout
  • From: dinesh kumar
• Re: [JDBC] JDBC connection test with SSL on PG 9.2.1 server
  • From: Hari Babu
• WARNING: pgstat wait timeout
  • From: Jake Stride
• Re: grouping consecutive records
  • From: Morus Walter
• Re: grouping consecutive records
  • From: Виктор Егоров
• Re: Diferences between IN and EXISTS?
  • From: Thomas Kellerer
• Re: Diferences between IN and EXISTS?
  • From: zeljko
• grouping consecutive records
  • From: Morus Walter
• Re: Weird explain output
  • From: wd
• Re: Using partial index in combination with prepared statement parameters
  • From: Tom Lane
• Re: Weird explain output
  • From: Tom Lane
• Weird explain output
  • From: wd
• Using partial index in combination with prepared statement parameters
  • From: Steven Schlansker
• Re: Syncing an application cache with xmin
  • From: Jason Dusek
• Re: Syncing an application cache with xmin
  • From: Tom Lane
• Syncing an application cache with xmin
  • From: Jason Dusek
• Re: Diferences between IN and EXISTS?
  • From: Fabrízio de Royes Mello
• Re: Optimizing query?
  • From: Jasen Betts
• Re: finding if a period is multiples of a given interval
  • From: Jasen Betts
• Re: Can LC_TIME affect timestamp input?
  • From: Jasen Betts
• Re: Is there a way to add a detail message in a warning with pl/Python?
  • From: Jasen Betts
• Re: finding if a period is multiples of a given interval
  • From: Jasen Betts
• Re: COPY table to file missing quotation marks
  • From: Jasen Betts
• Re: Diferences between IN and EXISTS?
  • From: Edson Richter
• Re: Diferences between IN and EXISTS?
  • From: Pavel Stehule
• Diferences between IN and EXISTS?
  • From: Edson Richter
• Re: What language is faster, C or PL/PgSQL?
  • From: Carlo Stonebanks
• Re: What language is faster, C or PL/PgSQL?
  • From: Ovnicraft
• What language is faster, C or PL/PgSQL?
  • From: Karel Riverón Escobar
• Re: Optimizing query?
  • From: Pavel Stehule
• Re: Optimizing query?
  • From: Pavel Stehule
• Re: Optimizing query?
  • From: hamann . w
• Re: trouble with upgrade from 9.0 (many schemas and tables)
  • From: Jeff Janes
• Re: Parsing COPY ... WITH BINARY
  • From: Leonardo M. Ramé
• ATET, could it be made "more concurrent" ?
  • From: Sahagian, David
• Re: Deleting 173000 records takes forever, blocks async queries for unrelated records
  • From: Carlo Stonebanks
• Re: [JDBC] JDBC connection test with SSL on PG 9.2.1 server
  • From: Adrian Klaver
• Re: [JDBC] JDBC connection test with SSL on PG 9.2.1 server
  • From: Hari Babu
• Re: Unusually high IO for autovacuum worker
  • From: Vlad Bailescu
• Re: Unusually high IO for autovacuum worker
  • From: Kevin Grittner
• Postgres version number support
  • From: Martin Gainty
• Re: Unusually high IO for autovacuum worker
  • From: Pavan Deolasee
• Windows documentation
  • From: Thomas Kellerer
• Re: Deleting 173000 records takes forever, blocks async queries for unrelated records
  • From: Bèrto ëd Sèra
• Re: Unusually high IO for autovacuum worker
  • From: Vlad Bailescu
• Re: Deleting 173000 records takes forever, blocks async queries for unrelated records
  • From: Alexander Farber
• Re: Unusually high IO for autovacuum worker
  • From: Pavan Deolasee
• Re: Deleting 173000 records takes forever, blocks async queries for unrelated records
  • From: Bèrto ëd Sèra
• Re: Deleting 173000 records takes forever, blocks async queries for unrelated records
  • From: Michal Politowski
• Re: Deleting 173000 records takes forever, blocks async queries for unrelated records
  • From: Albe Laurenz
• Re Deleting 173000 records takes forever
  • From: hamann . w
• Re: naming of wal-archives
  • From: Neil Worden
• Re: Unusually high IO for autovacuum worker
  • From: Vlad Bailescu
• Deleting 173000 records takes forever, blocks async queries for unrelated records
  • From: Alexander Farber
• Re: Unusually high IO for autovacuum worker
  • From: Pavan Deolasee
• Re: Unusually high IO for autovacuum worker
  • From: Pavel Stehule
• Unusually high IO for autovacuum worker
  • From: Vlad Bailescu
• Re: Optimizing query?
  • From: Pavel Stehule
• Re: Pg & Tcl - is it dying out?
  • From: Carlo Stonebanks
• Re: Parsing COPY ... WITH BINARY
  • From: Merlin Moncure
• Re: Pg & Tcl - is it dying out?
  • From: Adrian Klaver
• Re: Pg & Tcl - is it dying out?
  • From: Kevin Grittner
• Re: "CREATE TEMPORARY TABLE" does not work in SQL language function?
  • From: Tom Lane
• Re: SQL sentence to insert where updated rows is zero...
  • From: Vincent Veyron
• "CREATE TEMPORARY TABLE" does not work in SQL language function?
  • From: David Johnston
• Re: Pg & Tcl - is it dying out?
  • From: Carlo Stonebanks
• Re: Pg & Tcl - is it dying out?
  • From: David Fetter
• Re: Optimizing query?
  • From: hamann . w
• Pg & Tcl - is it dying out?
  • From: Carlo Stonebanks
• Re: Windows Phone/Postgresql
  • From: NickJonas
• Re: COPY table to file missing quotation marks
  • From: Adrian Klaver
• Re: COPY table to file missing quotation marks
  • From: Rich Shepard
• Re: COPY table to file missing quotation marks
  • From: Adrian Klaver
• Re: COPY table to file missing quotation marks
  • From: Steve Crawford
• Re: COPY table to file missing quotation marks
  • From: Rich Shepard
• Re: COPY table to file missing quotation marks
  • From: Steve Crawford
• Re: psql question
  • From: Little, Douglas
• Re: COPY table to file missing quotation marks
  • From: Rich Shepard
• Re: COPY table to file missing quotation marks
  • From: Adrian Klaver
• COPY table to file missing quotation marks
  • From: Rich Shepard
• SQL sentence to insert where updated rows is zero...
  • From: Glus Xof
• Re: AT TIME ZONE and interval arguments
  • From: Tom Lane
• Fwd: naming of wal-archives
  • From: Neil Worden
• Re: naming of wal-archives
  • From: Jeff Janes
• Re: Version numbers for binaries
  • From: deepak
• Re: naming of wal-archives
  • From: Adrian Klaver
• Parsing COPY ... WITH BINARY
  • From: Leonardo M. Ramé
• Re: Version numbers for binaries
  • From: Magnus Hagander
• Re: Optimizing query?
  • From: Pavel Stehule
• Re: Optimizing query?
  • From: Vincent Veyron
• Re: Windows Phone/Postgresql
  • From: Torello Querci
• Re: AT TIME ZONE and interval arguments
  • From: Albe Laurenz
• Re: Optimizing query?
  • From: Pavel Stehule
• Re: Optimizing query?
  • From: Vincent Veyron
• Re: naming of wal-archives
  • From: Neil Worden
• Re: naming of wal-archives
  • From: Neil Worden
• Re: Optimizing select count query which often takes over 10 seconds
  • From: Alexander Farber
• Re: naming of wal-archives
  • From: Neil Worden
• Re: Optimizing query?
  • From: Pavel Stehule
• AT TIME ZONE and interval arguments
  • From: Craig Ringer
• Re: Is there a way to add a detail message in a warning with pl/Python?
  • From: Stuart Bishop
• Re: Optimizing query?
  • From: Vincent Veyron
• Re: trouble with upgrade from 9.0 (many schemas and tables)
  • From: Groshev Andrey
• Re: psql question
  • From: Tom Lane
• Re: naming of wal-archives
  • From: Jeff Janes
• Version numbers for binaries
  • From: deepak
• Re: naming of wal-archives
  • From: Adrian Klaver
• Re: psql question
  • From: Steve Crawford
• psql question
  • From: Little, Douglas
• Re: naming of wal-archives
  • From: Jeff Janes
• Postbix Zabbix help
  • From: Raju Angani
• Optimizing query?
  • From: wolfgang
• [no subject]
  • From: News Subsystem
• naming of wal-archives
  • From: Neil Worden
• Re: Is there a way to add a detail message in a warning with pl/Python?
  • From: DANIEL CRISTIAN CRUZ
• Windows Phone/Postgresql
  • From: Bret Stern
• Re: database design best pratice help
  • From: Wolfgang Keller
• Re: pg_Restore
  • From: John R Pierce
• Cannot start PG as a Windows Service on Server 2008 and Windows 8
  • From: Brian Janes
• Query Parallelizing with dblink
  • From: AI Rumman
• Re: Optimizing select count query which often takes over 10 seconds
  • From: Jeff Janes
• Re: Is there a way to add a detail message in a warning with pl/Python?
  • From: Adrian Klaver
• Re: trouble with upgrade from 9.0 (many schemas and tables)
  • From: Tom Lane
• Re: trouble with upgrade from 9.0 (many schemas and tables)
  • From: Jeff Janes
• Re: optimize query?
  • From: hamann . w
• Re: finding if a period is multiples of a given interval
  • From: c k
• Re: pg_Restore
  • From: C. Bensend
• Re: Optimizing select count query which often takes over 10 seconds
  • From: Kevin Grittner
• Re: Optimizing select count query which often takes over 10 seconds
  • From: Kevin Grittner
• Re: pg_Restore
  • From: Eduardo Morras
• optimize query?
  • From: hamann . w
• Re: Fwd: Functions not visible in pg_stat_user_functions view
  • From: Bartosz Dmytrak
• Re: Fwd: Functions not visible in pg_stat_user_functions view
  • From: Albe Laurenz
• Re: Dropping default privileges.
  • From: Tim Uckun
• Re: Dropping default privileges.
  • From: Albe Laurenz
• Re: Optimizing select count query which often takes over 10 seconds
  • From: Alexander Farber
• Re: Fwd: Functions not visible in pg_stat_user_functions view
  • From: Bartosz Dmytrak
• Re: Optimizing select count query which often takes over 10 seconds
  • From: Alexander Farber
• trouble with upgrade from 9.0 (many schemas and tables)
  • From: Groshev Andrey
• Re: Dropping default privileges.
  • From: Tim Uckun
• Re: Dropping default privileges.
  • From: Tom Lane
• Dropping default privileges.
  • From: Tim Uckun
• Re: Optimizing select count query which often takes over 10 seconds
  • From: Kevin Grittner
• Re: Is there a way to add a detail message in a warning with pl/Python?
  • From: Adrian Klaver
• Is there a way to add a detail message in a warning with pl/Python?
  • From: DANIEL CRISTIAN CRUZ
• Re: inet/cidr ipv6 operations
  • From: Tom Lane
• Re: Fwd: Functions not visible in pg_stat_user_functions view
  • From: Adrian Klaver
• Re: Fwd: Functions not visible in pg_stat_user_functions view
  • From: Bartosz Dmytrak
• Re: Fwd: Functions not visible in pg_stat_user_functions view
  • From: Adrian Klaver
• Re: inet/cidr ipv6 operations
  • From: Chris Angelico
• Re: JDBC connection test with SSL on PG 9.2.1 server
  • From: Adrian Klaver
• Re: inet/cidr ipv6 operations
  • From: Tom Lane
• Re: inet/cidr ipv6 operations
  • From: Chris Angelico
• Re: Optimizing select count query which often takes over 10 seconds
  • From: Alexander Farber
• Fwd: Functions not visible in pg_stat_user_functions view
  • From: Bartosz Dmytrak
• inet/cidr ipv6 operations
  • From: George Shuklin
• JDBC connection test with SSL on PG 9.2.1 server
  • From: Hari Babu
• Re: [pgpool-general: 1315] Re: Database connections seemingly hanging
  • From: Fredrik . HuitfeldtMadsen
• Re: JDBC - Need to declare variables for values in insert statement
  • From: Bob Futrelle
• Re: finding if a period is multiples of a given interval
  • From: Steve Crawford
• Re: update performance of degenerate index
  • From: Filip Rembiałkowski
• Re: Installing PostgreSQL on OSX Server
  • From: David Salisbury
• update performance of degenerate index
  • From: Scott Ribe
• Re: Installing PostgreSQL on OSX Server
  • From: François Beausoleil
• Re: Installing PostgreSQL on OSX Server
  • From: Wolfgang Keller
• Re: main.log file not being updated
  • From: Adrian Klaver
• Re: JDBC - Need to declare variables for values in insert statement
  • From: Edson Richter
• Re: JDBC - Need to declare variables for values in insert statement
  • From: Bob Futrelle
• Re: database design best pratice help
  • From: Bob Futrelle
• Re: JDBC - Need to declare variables for values in insert statement
  • From: Dave Cramer
• Re: JDBC - Need to declare variables for values in insert statement
  • From: Edson Richter
• Re: JDBC - Need to declare variables for values in insert statement
  • From: Bob Futrelle
• Re: database design best pratice help
  • From: Kevin Grittner
• Re: main.log file not being updated
  • From: Anson Abraham
• Re: Best approach for query with optional constraints
  • From: Kevin Grittner
• Re: Installing PostgreSQL on OSX Server
  • From: Steve Atkins
• Re: Installing PostgreSQL on OSX Server
  • From: Stephen Cook
• Re: Installing PostgreSQL on OSX Server
  • From: Tom Lane
• Re: Installing PostgreSQL on OSX Server
  • From: Steve Atkins
• Re: finding if a period is multiples of a given interval
  • From: Adrian Klaver
• Re: finding if a period is multiples of a given interval
  • From: c k
• Re: Rules on views - Changes from 8.4 to 9.1 ?
  • From: Adrian Klaver
• Re: finding if a period is multiples of a given interval
  • From: Adrian Klaver
• Installing PostgreSQL on OSX Server
  • From: Stephen Cook
• Re: Can LC_TIME affect timestamp input?
  • From: Paul Jones
• Re: JDBC - Need to declare variables for values in insert statement
  • From: Dave Cramer
• finding if a period is multiples of a given interval
  • From: c k
• JDBC - Need to declare variables for values in insert statement
  • From: Bob Futrelle
• Rules on views - Changes from 8.4 to 9.1 ?
  • From: Leif Jensen
• Re: database design best pratice help
  • From: Albe Laurenz
• Re: database design best pratice help
  • From: Thomas Kellerer
• database design best pratice help
  • From: Jose Soares
• Re: Optimizing select count query which often takes over 10 seconds
  • From: Alexander Farber
• Re: Prevent out of memory errors by reducing work_mem?
  • From: Jan Strube
• Re: Optimizing select count query which often takes over 10 seconds
  • From: Jeff Janes
• Re: Finding common hstore key=>value pairs with hstore
  • From: Jeff Janes
• Re: Optimizing select count query which often takes over 10 seconds
  • From: Alexander Farber
• Best approach for query with optional constraints
  • From: Jon Smark
• Re: Postfresql 8.4 Problem
  • From: Adrian Klaver
• Re: Restore 1 Table from pg_dumpall?
  • From: Ondrej Ivanič
• Re: seeking SQL book recommendation
  • From: Rich Shepard
• Re: Restore 1 Table from pg_dumpall?
  • From: Rich Shepard
• Re: Finding common hstore key=>value pairs with hstore
  • From: Paul Norman
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Jasen Betts
• Re: Finding common hstore key=>value pairs with hstore
  • From: John R Pierce
• Finding common hstore key=>value pairs with hstore
  • From: Paul Norman
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Jasen Betts
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Jasen Betts
• Re: Running update in chunks?
  • From: Jasen Betts
• Re: Restore 1 Table from pg_dumpall?
  • From: Jasen Betts
• Re: Cast double precision to integer & check for overflow
  • From: Jasen Betts
• Re: noobie question
  • From: Scott Marlowe
• Re: Where Can I Find...
  • From: John R Pierce
• Re: Postfresql 8.4 Problem
  • From: Pavel Stehule
• Re: date_trunc to aggregate by timestamp?
  • From: Jasen Betts
• Re: Can LC_TIME affect timestamp input?
  • From: Jasen Betts
• Re: Temporary schemas
  • From: pamkiki
• Re: Cast double precision to integer & check for overflow
  • From: Jasen Betts
• Postfresql 8.4 Problem
  • From: Electric Boy
• Re: Running update in chunks?
  • From: Tim Uckun
• Re: Cast double precision to integer & check for overflow
  • From: Adrian Klaver
• Re: Cast double precision to integer & check for overflow
  • From: Gavan Schneider
• Re: Cast double precision to integer & check for overflow
  • From: Ian Pilcher
• Cast double precision to integer & check for overflow
  • From: Ian Pilcher
• Re: Range for user-defined SQLSTATE codes
  • From: Tom Lane
• Re: Range for user-defined SQLSTATE codes
  • From: Kevin Grittner
• Re: self join for history analyzis
  • From: Rafał Pietrak
• Re: self join for history analyzis
  • From: Alban Hertroys
• self join for history analyzis
  • From: Rafał Pietrak
• Re: Throttling Streamming Replication
  • From: Gavan Schneider
• Range for user-defined SQLSTATE codes
  • From: Ian Pilcher
• Re: Throttling Streamming Replication
  • From: Scott Marlowe
• Re: main.log file not being updated
  • From: Adrian Klaver
• Re: Optimizing select count query which often takes over 10 seconds
  • From: Jeff Janes
• Can LC_TIME affect timestamp input?
  • From: Paul Jones
• Re: Running update in chunks?
  • From: Jeff Janes
• Re: Where Can I Find...
  • From: Steve Atkins
• Where Can I Find...
  • From: Gene Poole
• Re: Optimizing select count query which often takes over 10 seconds
  • From: Guillaume Lelarge
• Re: Optimizing select count query which often takes over 10 seconds
  • From: Alexander Farber
• Re: Throttling Streamming Replication
  • From: Rodrigo Pereira da Silva
• Re: Prevent out of memory errors by reducing work_mem?
  • From: Tom Lane
• Re: Throttling Streamming Replication
  • From: Cliff de Carteret
• Re: Postgresql error
  • From: Craig Ringer
• Re: Throttling Streamming Replication
  • From: Magnus Hagander
• Throttling Streamming Replication
  • From: Rodrigo Pereira da Silva
• Re: seeking SQL book recommendation
  • From: James Cowell
• Re: Running update in chunks?
  • From: Albe Laurenz
• Re: Running update in chunks?
  • From: Richard Huxton
• Re: seeking SQL book recommendation
  • From: Scott Marlowe
• Re: Running update in chunks?
  • From: Tim Uckun
• Prevent out of memory errors by reducing work_mem?
  • From: Jan Strube
• Re: Running update in chunks?
  • From: Richard Huxton
• Re: Running update in chunks?
  • From: Tim Uckun
• Re: Running update in chunks?
  • From: Tim Uckun
• Re: Running update in chunks?
  • From: Tim Uckun
• Re: Running update in chunks?
  • From: Tim Uckun
• Re: noobie question
  • From: Bruno Wolff III
• Re: seeking SQL book recommendation
  • From: Bruno Wolff III
• Re: Postgresql error
  • From: Adrian Klaver
• Re: Postgresql error
  • From: Kevin Grittner
• Re: SELinux users - Please consider testing SELinux/SEPostgreSQL patches
  • From: Craig Ringer
• Postgresql error
  • From: MarkB
• Re: main.log file not being updated
  • From: Anson Abraham
• Re: main.log file not being updated
  • From: Adrian Klaver
• Re: main.log file not being updated
  • From: Adrian Klaver
• Re: Optimizing select count query which often takes over 10 seconds
  • From: Guillaume Lelarge
• Re: noobie question
  • From: Steve Clark
• Re: main.log file not being updated
  • From: Adrian Klaver
• Re: main.log file not being updated
  • From: Anson Abraham
• Re: noobie question
  • From: Chris Angelico
• Re: noobie question
  • From: Gauthier, Dave
• date_trunc to aggregate by timestamp?
  • From: Kirk Wythers
• Re: noobie question
  • From: Steve Clark
• Re: main.log file not being updated
  • From: Adrian Klaver
• Re: noobie question
  • From: Jeff Janes
• main.log file not being updated
  • From: Anson Abraham
• Re: noobie question
  • From: Adrian Klaver
• Re: noobie question
  • From: Gauthier, Dave
• Re: noobie question
  • From: Chris Angelico
• noobie question
  • From: Steve Clark
• Re: Optimizing select count query which often takes over 10 seconds
  • From: Alban Hertroys
• Re: How to identify the source of a deadlock?
  • From: Albe Laurenz
• Re: DB alias ?
  • From: Albe Laurenz
• How to identify the source of a deadlock?
  • From: Stefan Froehlich
• Re: Optimizing select count query which often takes over 10 seconds
  • From: Alexander Farber
• Re: Optimizing select count query which often takes over 10 seconds
  • From: Alban Hertroys
• Re: DB alias ?
  • From: Gauthier, Dave
• Re: Logging successful SELECTS?
  • From: Pavel Stehule
• Re: Logging successful SELECTS?
  • From: Виктор Егоров
• Re: Optimizing select count query which often takes over 10 seconds
  • From: Moshe Jacobson
• Logging successful SELECTS?
  • From: Matthew Vernon
• Optimizing select count query which often takes over 10 seconds
  • From: Alexander Farber
• Re: Jobs for a Oracle/Postgres DBAs in Australia
  • From: Joshua D. Drake
• Re: DB alias ?
  • From: Albe Laurenz
• Re: DB alias ?
  • From: Guillaume Lelarge
• Jobs for a Oracle/Postgres DBAs in Australia
  • From: Cameron Shorter
• Re: DB alias ?
  • From: Shridhar Daithankar
• Re: Sending several commands simultaneously to PostgreSQL 8.4
  • From: Jeff Janes
• Re: Sending several commands simultaneously to PostgreSQL 8.4
  • From: Jeff Janes
• Re: seeking SQL book recommendation
  • From: Rob Sargent
• Re: seeking SQL book recommendation
  • From: Thomas Kellerer
• Re: Sending several commands simultaneously to PostgreSQL 8.4
  • From: Alexander Farber
• Re: seeking SQL book recommendation
  • From: John R Pierce
• Re: seeking SQL book recommendation
  • From: Thomas Kellerer
• seeking SQL book recommendation
  • From: Scott Ribe
• Re: Replacement for Oracle Workspace Manager
  • From: Joshua D. Drake
• Replacement for Oracle Workspace Manager
  • From: Devrim GÜNDÜZ
• Re: DB alias ?
  • From: Steve Crawford
• Re: DB alias ?
  • From: Andrew Sullivan
• Re: DB alias ?
  • From: Gauthier, Dave
• Re: Fwd: Question on Trigram GIST indexes
  • From: ERR ORR
• Re: DB alias ?
  • From: Gauthier, Dave
• Re: DB alias ?
  • From: Steve Crawford
• Re: DB alias ?
  • From: John R Pierce
• Re: DB alias ?
  • From: Rob Sargent
• Re: DB alias ?
  • From: Gauthier, Dave
• Re: DB alias ?
  • From: Joshua D. Drake
• Re: DB alias ?
  • From: Alvaro Herrera
• DB alias ?
  • From: Gauthier, Dave
• Re: Trouble with Postgresql RPM
  • From: Alan Hodgson
• Trouble with Postgresql RPM
  • From: Ian Harding
• Re: Running update in chunks?
  • From: Kevin Grittner
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Gavan Schneider
• Re: Pg_xlog increase due to postgres crash (disk full)
  • From: Cliff de Carteret
• Re: Fwd: Question on Trigram GIST indexes
  • From: Tom Lane
• Re: What is the impact of "varchar_pattern_ops" on performance and/or memory
  • From: Edson Richter
• Re: What is the impact of "varchar_pattern_ops" on performance and/or memory (was: What is impact of "varchar_ops")?
  • From: Tom Lane
• Re: Running update in chunks?
  • From: Steve Crawford
• Re: What is the impact of "varchar_pattern_ops" on performance and/or memory
  • From: Edson Richter
• Re: Restore 1 Table from pg_dumpall?
  • From: Steve Crawford
• Re: PostgreS Security Concern
  • From: Vincent Veyron
• Re: Running update in chunks?
  • From: Alvaro Herrera
• Re: Running update in chunks?
  • From: Steve Crawford
• Re: Running update in chunks?
  • From: Steve Crawford
• Re: Restore 1 Table from pg_dumpall?
  • From: Kevin Grittner
• Re: Pg_xlog increase due to postgres crash (disk full)
  • From: Kevin Grittner
• Re: Restore 1 Table from pg_dumpall? [RESOLVED]
  • From: Rich Shepard
• Re: Restore 1 Table from pg_dumpall? [RESOLVED]
  • From: Joshua D. Drake
• Re: Restore 1 Table from pg_dumpall? [RESOLVED]
  • From: Rich Shepard
• What is the impact of "varchar_pattern_ops" on performance and/or memory (was: What is impact of "varchar_ops")?
  • From: Edson Richter
• Restore 1 Table from pg_dumpall?
  • From: Rich Shepard
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Steve Crawford
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Gavin Flower
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Gavan Schneider
• Re: Pg_xlog increase due to postgres crash (disk full)
  • From: Cliff de Carteret
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Steve Crawford
• Re: Pg_xlog increase due to postgres crash (disk full)
  • From: Kevin Grittner
• Re: How do I install pgcrypto in postgresql 9.2 on Linux
  • From: Adrian Klaver
• Re: Pg_xlog increase due to postgres crash (disk full)
  • From: Cliff de Carteret
• How do I install pgcrypto in postgresql 9.2 on Linux
  • From: Srinath Reddy
• Re: cache lookup failed
  • From: Pascal Tufenkji
• PostgreS Security Concern
  • From: Roela B Montecillo
• Re: Pg_xlog increase due to postgres crash (disk full)
  • From: Adrian Klaver
• Re: Pg_xlog increase due to postgres crash (disk full)
  • From: Kevin Grittner
• Re: Pg_xlog increase due to postgres crash (disk full)
  • From: Cliff de Carteret
• Re: Pg_xlog increase due to postgres crash (disk full)
  • From: Adrian Klaver
• Re: Update rule on a view - what am I doing wrong
  • From: Leif Jensen
• Re: Pg_xlog increase due to postgres crash (disk full)
  • From: Cliff de Carteret
• Re: Pg_xlog increase due to postgres crash (disk full)
  • From: Adrian Klaver
• Re: RAISE NOTICE ... and CONTEXT field of the error report.
  • From: Dmitriy Igrishin
• Re: Question on Trigram GIST indexes
  • From: Merlin Moncure
• Re: Question on Trigram GIST indexes
  • From: Merlin Moncure
• Re: RAISE NOTICE ... and CONTEXT field of the error report.
  • From: Marc Schablewski
• RAISE NOTICE ... and CONTEXT field of the error report.
  • From: Dmitriy Igrishin
• Re: Update rule on a view - what am I doing wrong
  • From: Marc Schablewski
• Re: Update rule on a view - what am I doing wrong
  • From: Leif Jensen
• Pg_xlog increase due to postgres crash (disk full)
  • From: Cliff de Carteret
• Re: Question on Trigram GIST indexes
  • From: Johann Spies
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Nathan Clayton
• Re: Running update in chunks?
  • From: Jeff Janes
• Re: Running update in chunks?
  • From: Jeff Janes
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Gavan Schneider
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Gavan Schneider
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Tom Lane
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Adrian Klaver
• Re: cache lookup failed
  • From: Tom Lane
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Gavan Schneider
• cache lookup failed
  • From: Pascal Tufenkji
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Kevin Grittner
• Re: Running update in chunks?
  • From: Kevin Grittner
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Adrian Klaver
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Kevin Grittner
• Re: Running update in chunks?
  • From: Tim Uckun
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Adrian Klaver
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Adrian Klaver
• Re: Running update in chunks?
  • From: Steve Crawford
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Gavan Schneider
• Re: Running update in chunks?
  • From: Steve Crawford
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Steve Crawford
• Re: Running update in chunks?
  • From: Tim Uckun
• Re: Running update in chunks?
  • From: Tim Uckun
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Gavan Schneider
• Re: Case insensitive collation
  • From: Jeff Janes
• Re: Case insensitive collation
  • From: Thomas Kellerer
• Re: What is impact of "varchar_opts"?
  • From: Edson Richter
• Re: Running update in chunks?
  • From: Kevin Grittner
• Re: Case insensitive collation
  • From: Kevin Grittner
• Re: Running update in chunks?
  • From: patrick keshishian
• Re: Running update in chunks?
  • From: Kevin Grittner
• Re: Running update in chunks?
  • From: Kevin Grittner
• Re: Running update in chunks?
  • From: Tim Uckun
• Re: Case insensitive collation
  • From: Scott Marlowe
• Re: Running update in chunks?
  • From: Tim Uckun
• Re: Running update in chunks?
  • From: patrick keshishian
• Re: pg_Restore
  • From: Kevin Grittner
• Re: Running update in chunks?
  • From: Richard Huxton
• Re: What is impact of "varchar_opts"?
  • From: Tom Lane
• Re: What is impact of "varchar_opts"?
  • From: Edson Richter
• Re: Running update in chunks?
  • From: Tim Uckun
• Re: What is impact of "varchar_opts"?
  • From: Tom Lane
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Adrian Klaver
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Adrian Klaver
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Rich Shepard
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Tom Lane
• Re: What is impact of "varchar_opts"?
  • From: Edson Richter
• Re: What is impact of "varchar_opts"?
  • From: Tom Lane
• Re: Running update in chunks?
  • From: Kevin Grittner
• Re: pg_Restore
  • From: Adrian Klaver
• Re: pg_Restore
  • From: bhanu udaya
• Re: Case insensitive collation
  • From: Alban Hertroys
• Re: Case insensitive collation
  • From: Marcel van Pinxteren
• Re: Case insensitive collation
  • From: Scott Marlowe
• Re: pg_Restore
  • From: bhanu udaya
• Re: not(t_xmax = 0)
  • From: Kevin Grittner
• Re: pg_Restore
  • From: Alan Hodgson
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Rich Shepard
• Re: String comparison and the SQL standard
  • From: Albe Laurenz
• Re: Yet Another Timestamp Question: Time Defaults
  • From: Adrian Klaver
• Yet Another Timestamp Question: Time Defaults
  • From: Rich Shepard
• Re: pg_Restore
  • From: Alban Hertroys
• Re: pg_Restore
  • From: Albe Laurenz
• Re: pg_Restore
  • From: bhanu udaya
• Re: Sending several commands simultaneously to PostgreSQL 8.4
  • From: Alexander Farber
• Re: Sending several commands simultaneously to PostgreSQL 8.4
  • From: Alexander Farber
• Re: pg_Restore
  • From: Chris Ernst
• Sending several commands simultaneously to PostgreSQL 8.4
  • From: Alexander Farber
• What is impact of "varchar_opts"?
  • From: Edson Richter
• Re: Case insensitive collation
  • From: Thomas Kellerer
• Re: Case insensitive collation
  • From: Marcel van Pinxteren
• Re: pg_Restore
  • From: Chris Travers
• Re: pg_Restore
  • From: dinesh kumar
• Re: pg_Restore
  • From: Albe Laurenz
• Re: Running update in chunks?
  • From: Richard Huxton
• Re: Running update in chunks?
  • From: Tim Uckun
• Re: pg_Restore
  • From: Raghavendra
• Re: pg_Restore
  • From: bhanu udaya
• Re: Running update in chunks?
  • From: Richard Huxton
• Running update in chunks?
  • From: Tim Uckun
• SELinux users - Please consider testing SELinux/SEPostgreSQL patches
  • From: Craig Ringer
• Re: pg_Restore
  • From: Magnus Hagander
• Care about Cygwin support? Please help test a patch.
  • From: Craig Ringer
• Re: pg_Restore
  • From: bhanu udaya
• Re: Understanding TIMESTAMP WITH TIME ZONE
  • From: Adrian Klaver
• Re: pg_Restore
  • From: François Beausoleil
• Re: Understanding TIMESTAMP WITH TIME ZONE
  • From: François Beausoleil
• Re: pg_Restore
  • From: bhanu udaya
• Re: Re: [HACKERS] Overly strict casting rules? (was: proposal: fix corner use case of variadic fuctions usage)
  • From: Chris Travers
• Re: [HACKERS] Overly strict casting rules? (was: proposal: fix corner use case of variadic fuctions usage)
  • From: Craig Ringer
• Re: not(t_xmax = 0)
  • From: Alejandro Carrillo
• Re: Understanding TIMESTAMP WITH TIME ZONE
  • From: Adrian Klaver
• Re: Understanding TIMESTAMP WITH TIME ZONE
  • From: Adrian Klaver
• Re: Understanding TIMESTAMP WITH TIME ZONE
  • From: Robert James
• Re: not(t_xmax = 0)
  • From: Tom Lane
• Re: not(t_xmax = 0)
  • From: Kevin Grittner
• Re: not(t_xmax = 0)
  • From: Alejandro Carrillo
• Re: not(t_xmax = 0)
  • From: Kevin Grittner
• Re: Cannot install postgres 9.2, less than 32 MB of memory
  • From: Alexander Reichstadt
• not(t_xmax = 0)
  • From: Alejandro Carrillo
• Re: Libpq and multithreading
  • From: Ashesh Vashi
• Re: Combine Date and Time Columns to Timestamp
  • From: Gavin Flower
• Re: Cannot install postgres 9.2, less than 32 MB of memory
  • From: Tom Lane
• Re: Combine Date and Time Columns to Timestamp
  • From: Kevin Grittner
• Re: Cannot install postgres 9.2, less than 32 MB of memory
  • From: Raghavendra
• Re: Cannot install postgres 9.2, less than 32 MB of memory
  • From: Adrian Klaver
• Re: Combine Date and Time Columns to Timestamp
  • From: Rich Shepard
• Cannot install postgres 9.2, less than 32 MB of memory
  • From: Alexander Reichstadt
• Re: Logging affected rows
  • From: Raghavendra
• Re: Logging affected rows
  • From: Raghavendra
• Re: pg_upgrade problem from 8.4 to 9.2 problems on OSX
  • From: Tom Lane
• Re: pg_upgrade problem from 8.4 to 9.2 problems on OSX
  • From: Bruce Momjian
• Re: Update rule on a view - what am I doing wrong
  • From: Jasen Betts
• Re: Combine Date and Time Columns to Timestamp
  • From: Adrian Klaver
• Re: SELECT * and column ordering
  • From: Jasen Betts
• Re: Combine Date and Time Columns to Timestamp
  • From: Steven Schlansker
• Re: Combine Date and Time Columns to Timestamp
  • From: Adrian Klaver
• Re: Combine Date and Time Columns to Timestamp
  • From: Rich Shepard
• multiple stored procedures usage and updation
  • From: sumesh
• Re: pg_upgrade problem from 8.4 to 9.2 problems on OSX
  • From: Charles Porter
• Logging affected rows
  • From: classical_89
• Re: How to store clickmap points?
  • From: aasat
• Re: Combine Date and Time Columns to Timestamp
  • From: Adrian Klaver
• Re: Libpq and multithreading
  • From: Asia
• Combine Date and Time Columns to Timestamp
  • From: Rich Shepard
• Re: Sample databases
  • From: Vraj Mohan
• Re: Temp table's effect on performance
  • From: Kevin Grittner
• Re: Understanding TIMESTAMP WITH TIME ZONE
  • From: Steve Crawford
• Re: Temp table's effect on performance
  • From: Tom Lane
• Re: Temp table's effect on performance
  • From: Robert James
• Re: Temp table's effect on performance
  • From: Tom Lane
• Re: Temp table's effect on performance
  • From: Jeff Janes
• Re: Case insensitive collation
  • From: Alex Hunsaker
• Re: Understanding TIMESTAMP WITH TIME ZONE
  • From: Adrian Klaver
• Re: Temp table's effect on performance
  • From: Pavel Stehule
• Understanding TIMESTAMP WITH TIME ZONE
  • From: Robert James
• Temp table's effect on performance
  • From: Robert James
• Re: speeding up a join query that utilizes a view
  • From: Igor Neyman
• Re: reducing number of ANDs speeds up query RESOLVED
  • From: Eduardo Morras
• Re: speeding up a join query that utilizes a view
  • From: Kirk Wythers
• Re: speeding up a join query that utilizes a view
  • From: Igor Neyman
• Re: Update rule on a view - what am I doing wrong
  • From: Tom Lane
• Re: speeding up a join query that utilizes a view
  • From: Kirk Wythers
• Re: String comparison and the SQL standard
  • From: Tom Lane
• Update rule on a view - what am I doing wrong
  • From: Leif Jensen
• Re: speeding up a join query that utilizes a view
  • From: Igor Neyman
• Re: Case insensitive collation
  • From: Thomas Kellerer
• Re: Case insensitive collation
  • From: Alban Hertroys
• Re: Case insensitive collation
  • From: Marcel van Pinxteren
• Re: SELECT DISTINCT
  • From: salah jubeh
• Re: String comparison and the SQL standard
  • From: Albe Laurenz
• Re: Case insensitive collation
  • From: Jasen Betts
• Re: Best method to compare subdomains
  • From: Jasen Betts
• Functions not visible in pg_stat_user_functions view
  • From: Bartosz Dmytrak
• Re: SELECT DISTINCT
  • From: Tom Lane
• Re: SELECT DISTINCT
  • From: Kevin Grittner
• Loggin SQL warnings in JDBC driver
  • From: Edson Richter
• Re: speeding up a join query that utilizes a view
  • From: Kirk Wythers
• Re: speeding up a join query that utilizes a view
  • From: Igor Neyman
• Re: String comparison and the SQL standard
  • From: Kevin Grittner
• Re: speeding up a join query that utilizes a view
  • From: Kirk Wythers
• SELECT DISTINCT
  • From: salah jubeh
• Re: Determine if an index is a B-tree, GIST, or something else?
  • From: Paul Jungwirth
• Re: Determine if an index is a B-tree, GIST, or something else?
  • From: Tom Lane
• Re: Determine if an index is a B-tree, GIST, or something else?
  • From: Paul Jungwirth
• Re: Determine if an index is a B-tree, GIST, or something else?
  • From: Devrim GÜNDÜZ
• Re: Linux Distribution Preferences?
  • From: Vincent Veyron
• Re: Determine if an index is a B-tree, GIST, or something else?
  • From: Ben Chobot
• Determine if an index is a B-tree, GIST, or something else?
  • From: Paul Jungwirth
• Re: Libpq and multithreading
  • From: Merlin Moncure
• Re: String comparison and the SQL standard
  • From: Tom Lane
• Re: speeding up a join query that utilizes a view
  • From: Igor Neyman
• standby, pg_basebackup and last xlog file
  • From: Миша Тюрин
• Re: plpython intermittent ImportErrors
  • From: Brian Sutherland
• Re: plpython intermittent ImportErrors
  • From: Alban Hertroys
• Fwd: Sample databases
  • From: Vraj Mohan
• Re: plpython intermittent ImportErrors
  • From: Brian Sutherland
• Re: String comparison and the SQL standard
  • From: Albe Laurenz
• String comparison and the SQL standard
  • From: Albe Laurenz
• Re: Best method to compare subdomains
  • From: John R Pierce
• Re: Best method to compare subdomains
  • From: Sumit Raja
• Re: plpython intermittent ImportErrors
  • From: Stuart Bishop
• Streaming Replication Failover
  • From: ning chan
• speeding up a join query that utilizes a view
  • From: Kirk Wythers
• Re: Sample databases
  • From: Jeff Janes
• Re: How to store clickmap points?
  • From: Shane Spencer
• Re: Triggers operations and log_statement = all not working?
  • From: Edson Richter
• Re: pg_upgrade problem from 8.4 to 9.2 problems on OSX
  • From: Bruce Momjian
• Re: How to store clickmap points?
  • From: aasat
• Re: How to store clickmap points?
  • From: aasat
• Re: Libpq and multithreading
  • From: Asia
• Re: INSERT... WHERE
  • From: David Johnston
• Re: argument of AND must not return a set when using regexp_matches
  • From: Tom Lane
• pg_upgrade problem from 8.4 to 9.2 problems on OSX
  • From: Charles Porter
• Re: Best method to compare subdomains
  • From: Steve Atkins
• Re: reducing number of ANDs speeds up query RESOLVED
  • From: T. E. Lawrence
• Re: reducing number of ANDs speeds up query RESOLVED
  • From: T. E. Lawrence
• argument of AND must not return a set when using regexp_matches
  • From: Robert James
• Re: Best method to compare subdomains
  • From: Andrew Sullivan
• Best method to compare subdomains
  • From: Robert James
• Re: Case insensitive collation
  • From: Marcel van Pinxteren
• Re: Case insensitive collation
  • From: Tom Lane
• Case insensitive collation
  • From: Marcel van Pinxteren
• Re: plpython intermittent ImportErrors RESOLVED
  • From: Adrian Klaver
• Re: Enhancement proposal - detect chain of triggers from inside the trigger
  • From: Edson Richter
• Re: plpython intermittent ImportErrors RESOLVED
  • From: Brian Sutherland
• Re: SELECT * and column ordering
  • From: Rob Sargent
• Re: Enhancement proposal - detect chain of triggers from inside the trigger
  • From: Tom Lane
• Triggers operations and log_statement = all not working?
  • From: Edson Richter
• Re: Sample databases
  • From: Carlos Mennens
• Sample databases
  • From: Vraj Mohan
• Re: Independent backups of subdatabases
  • From: Adrian Klaver
• Re: Linux Distribution Preferences?
  • From: SUNDAY A. OLUTAYO
• Re: plpython intermittent ImportErrors
  • From: Brian Sutherland
• Re: Linux Distribution Preferences?
  • From: Stuart Bishop
• Re: Enhancement proposal - detect chain of triggers from inside the trigger
  • From: Pavel Stehule
• Re: [pgpool-general: 1315] Re: Database connections seemingly hanging
  • From: Tatsuo Ishii
• Re: Independent backups of subdatabases
  • From: John R Pierce
• Independent backups of subdatabases
  • From: Robert James
• Re: SELECT * and column ordering
  • From: Meta Seller Dev/Admin
• Re: Getting Mysql data into Postgres: least painful methods?
  • From: Adrian Klaver
• Re: SELECT * and column ordering
  • From: Rob Sargent
• Re: Getting Mysql data into Postgres: least painful methods?
  • From: Ken Tanzer
• Re: Getting Mysql data into Postgres: least painful methods?
  • From: Adrian Klaver
• SELECT * and column ordering
  • From: Meta Seller Dev/Admin
• Re: Linux Distribution Preferences?
  • From: Scott Marlowe
• Re: Getting Mysql data into Postgres: least painful methods?
  • From: Ken Tanzer
• Re: Enhancement proposal - detect chain of triggers from inside the trigger
  • From: Edson Richter
• Re: Enhancement proposal - detect chain of triggers from inside the trigger
  • From: Adrian Klaver
• Enhancement proposal - detect chain of triggers from inside the trigger
  • From: Edson Richter
• Re: [SQL] Curious problem of using BETWEEN with start and end being the same versus EQUALS '='
  • From: Venky Kandaswamy
• Re: [SQL] Curious problem of using BETWEEN with start and end being the same versus EQUALS '='
  • From: Tom Lane
• Re: 9.2 upgrade glitch with search_path
  • From: Tom Lane
• Re: plpython intermittent ImportErrors
  • From: Chris Angelico
• Re: 9.2 upgrade glitch with search_path
  • From: Bruce Momjian
• Re: Linux Distribution Preferences?
  • From: Bruce Momjian
• Re: Linux Distribution Preferences?
  • From: Vincent Veyron
• Curious problem of using BETWEEN with start and end being the same versus EQUALS '='
  • From: Venky Kandaswamy
• Re: Recommendations on plpgsql debugger?
  • From: Glyn Astill
• Re: Streaming Replication
  • From: Fujii Masao
• Re: Recommendations on plpgsql debugger?
  • From: Gauthier, Dave
• Re: reducing number of ANDs speeds up query RESOLVED
  • From: Jeff Janes
• Re: Streaming Replication
  • From: ning chan
• Re: reducing number of ANDs speeds up query RESOLVED
  • From: Tom Lane
• Re: Linux Distribution Preferences?
  • From: Scott Marlowe
• Re: Linux Distribution Preferences?
  • From: Vincent Veyron
• Re: Linux Distribution Preferences?
  • From: Daniel Verite
• Re: Linux Distribution Preferences?
  • From: Vincent Veyron
• nonexistent user in pg_class.relacl messing pg_dump output
  • From: Filip Rembiałkowski
• Re: INSERT... WHERE
  • From: Serge Fonville
• Re: INSERT... WHERE
  • From: Serge Fonville
• Re: reducing number of ANDs speeds up query RESOLVED
  • From: T. E. Lawrence
• Re: Recommendations on plpgsql debugger?
  • From: Albe Laurenz
• Re: Streaming Replication
  • From: Albe Laurenz