Postgresql General Discussion

• Thread Index

• Re: Overhead of union versus union all
  • From: Alvaro Herrera
• Overhead of union versus union all
  • From: Tim Keitt
• Help me please...
  • From: Roseller A. Romanos
• Postgres 8.4 literal escaping
  • From: Niederland
• Re: Trying to find a low-cost program for Data migration and ETL
  • From: Tguru
• Re: constraint checking on partitions
  • From: Chris Spotts
• Re: constraint checking on partitions
  • From: Tom Lane
• Re: constraint checking on partitions
  • From: Chris Spotts
• Re: constraint checking on partitions
  • From: Tom Lane
• Re: Asking for assistance in determining storage requirements
  • From: Vick Khera
• Re: ZFS prefetch considered evil?
  • From: John R Pierce
• constraint checking on partitions
  • From: Chris Spotts
• Re: is autovacuum recommended?
  • From: Bill Moran
• Re: is autovacuum recommended?
  • From: Andres Freund
• Re: Performance problem with low correlation data
  • From: Alvaro Herrera
• Re: is autovacuum recommended?
  • From: Alvaro Herrera
• is autovacuum recommended?
  • From: Willy-Bas Loos
• Re: Table replication
  • From: Arndt Lehmann
• Re: Checkpoint Tuning Question
  • From: Dan Armbrust
• Re: SELECT DISTINCT very slow
  • From: Pavel Stehule
• Re: SELECT DISTINCT very slow
  • From: Andres Freund
• Re: SELECT DISTINCT very slow
  • From: Bill Moran
• Re: [Password?]
  • From: Ms swati chande
• PostgreSQL 8.4 Window functions
  • From: Paolo Saudin
• Asking for assistance in determining storage requirements
  • From: Chris Barnes
• SELECT DISTINCT very slow
  • From: Ben Harper
• Re: Bug in ecpg lib ?
  • From: leif
• Re: ZFS prefetch considered evil?
  • From: Alban Hertroys
• Re: c++ program to connect to postgre database
  • From: Peter Geoghegan
• Re: c++ program to connect to postgre database
  • From: Rainer Bauer
• Re: Table replication
  • From: Richard Huxton
• Re: pg_dump PostgreSQL 8.4
  • From: Dave Page
• Re: pg_dump PostgreSQL 8.4
  • From: serafin segador
• Re: sslv3 alert illegal parameter [SOLVED]
  • From: Pedro Doria Meunier
• Re: c++ program to connect to postgre database
  • From: Pedro Doria Meunier
• Table replication
  • From: S Arvind
• Re: pg_dump PostgreSQL 8.4
  • From: Frank Heikens
• pg_dump PostgreSQL 8.4
  • From: serafin g.segador
• Re: c++ program to connect to postgre database
  • From: John R Pierce
• Re: Performance problem with low correlation data
  • From: m_lists
• Re: sslv3 alert illegal parameter
  • From: Albe Laurenz
• Re: ZFS prefetch considered evil?
  • From: Greg Smith
• Re: ZFS prefetch considered evil?
  • From: Scott Marlowe
• Re: PostgreSQL and Poker
  • From: Scott Marlowe
• Re: c++ program to connect to postgre database
  • From: John R Pierce
• c++ program to connect to postgre database
  • From: ramon rhey serrano
• Re: PostgreSQL and Poker
  • From: Greg Smith
• Re: ZFS prefetch considered evil?
  • From: Yaroslav Tykhiy
• Re: Password?
  • From: Adrian Klaver
• Re: PostgreSQL and Poker
  • From: Erik Jones
• temp tables and replication/connection sharing/pooling
  • From: Ivan Sergio Borgonovo
• Re: Checkpoint Tuning Question
  • From: Tom Lane
• Re: Problem search on text arrays, using the overlaps (&&) operator
  • From: John Cheng
• Re: PostgreSQL and Poker
  • From: Leif B. Kristensen
• Re: Oracle Help in PG?
  • From: Steve Atkins
• Re: Oracle Help in PG?
  • From: Martin Gainty
• Re: Checkpoint Tuning Question
  • From: Dan Armbrust
• Re: Checkpoint Tuning Question
  • From: Greg Smith
• Re: Checkpoint Tuning Question
  • From: Tom Lane
• Re: PostgreSQL and Poker
  • From: Ivan Sergio Borgonovo
• Re: PostgreSQL and Poker
  • From: Greg Smith
• Re: Checkpoint Tuning Question
  • From: John R Pierce
• Re: Checkpoint Tuning Question
  • From: Tom Lane
• Re: "= Null" <> "is Null"?
  • From: Scott Bailey
• Re: Oracle Help in PG?
  • From: Scott Marlowe
• Re: Checkpoint Tuning Question
  • From: Greg Smith
• Re: Checkpoint Tuning Question
  • From: Greg Smith
• Re: about pg_stat_get_db_xact_commit
  • From: Alvaro Herrera
• Re: Password?
  • From: John R Pierce
• Re: PostgreSQL and Poker
  • From: Scott Marlowe
• Re: Checkpoint Tuning Question
  • From: Dan Armbrust
• Re: now() + '4d' AT TIME ZONE issue
  • From: Madison Kelly
• Re: Password?
  • From: Andreas Wenk
• Oracle Help in PG?
  • From: SHARMILA JOTHIRAJAH
• Re: Password?
  • From: Ms swati chande
• Re: now() + '4d' AT TIME ZONE issue
  • From: Tom Lane
• Re: Checkpoint Tuning Question
  • From: Tom Lane
• Re: now() + '4d' AT TIME ZONE issue
  • From: Chris Spotts
• Re: [Re: Password?]
  • From: Ms swati chande
• now() + '4d' AT TIME ZONE issue
  • From: Madison Kelly
• Re: Checkpoint Tuning Question
  • From: Dan Armbrust
• Re: PostgreSQL and Poker
  • From: Ivan Sergio Borgonovo
• Re: Checkpoint Tuning Question
  • From: Dan Armbrust
• Re: Checkpoint Tuning Question
  • From: Tom Lane
• Re: [Re: Password?]
  • From: Andreas Wenk
• PostgreSQL and Poker
  • From: Massa, Harald Armin
• Re: [Re: Password?]
  • From: Raymond O'Donnell
• Checkpoint Tuning Question
  • From: Dan Armbrust
• Re: [Re: Password?]
  • From: Steve Atkins
• Happy Birthday...
  • From: Joshua Tolley
• Re: [Re: Password?]
  • From: Raymond O'Donnell
• Re: [Re: Password?]
  • From: Steve Atkins
• Re: INTERVAL documentation bug?
  • From: Tom Lane
• Re: Client only install
  • From: Pavel Stehule
• Client only install
  • From: Michael Gould
• INTERVAL documentation bug?
  • From: Sebastien FLAESCH
• Re: "= Null" <> "is Null"?
  • From: Scott Marlowe
• Re: [Re: Password?]
  • From: Andreas Wenk
• Re: [Re: Password?]
  • From: Jasen Betts
• Re: singletons per row in table AND locking response
  • From: Hartman, Matthew
• Re: "= Null" <> "is Null"?
  • From: Dimitri Fontaine
• Re: howto determine rows count to be returned by DECLARE ... SELECT ...
  • From: Dimitri Fontaine
• Re: "= Null" <> "is Null"?
  • From: Alban Hertroys
• Re: [Re: Password?]
  • From: Ms swati chande
• "= Null" <> "is Null"?
  • From: Durumdara
• sslv3 alert illegal parameter
  • From: Pedro Doria Meunier
• Re: Password?
  • From: Ms swati chande
• Re: Password?
  • From: Abbas
• Re: Problem search on text arrays, using the overlaps (&&) operator
  • From: nha
• Re: Password?
  • From: Andreas Wenk
• Re: Password?
  • From: Andreas Wenk
• Re: Password?
  • From: Abbas
• Re: Normalize INTERVAL ouput format in a db driver
  • From: Sebastien FLAESCH
• Re: ZFS prefetch considered evil?
  • From: Alban Hertroys
• Re: Bug in ecpg lib ?
  • From: Albe Laurenz
• [Re: Password?]
  • From: Andreas Wenk
• Re: Password?
  • From: Andreas Wenk
• Re: Password?
  • From: Andreas Wenk
• Password?
  • From: Ms swati chande
• Re: Passing a table to function
  • From: Grzegorz Jaśkiewicz
• pqSocketCheck() didn't return, hung in poll()? Is it a bug?
  • From: Lizzy M
• Re: Bug in ecpg lib ?
  • From: leif
• Re: Bug in ecpg lib ?
  • From: Albe Laurenz
• Polygon data type
  • From: Mark Gabriel Paylaga
• Re: Warm standby: 1 to N
  • From: Yar Tikhiy
• Re: Postgres 8.3.7 Server Crash: failed to add item to the right sibling in index
  • From: CM J
• Re: Replication
  • From: Tim Uckun
• Re: [PERFORM] Postgres Clustering
  • From: Tim Uckun
• Re: singletons per row in table AND locking response
  • From: Dennis Gearon
• singletons per row in table AND locking response
  • From: Dennis Gearon
• Re: End of updates info
  • From: Bruce Momjian
• Re: Compiling using Visual Studio 2005
  • From: Ms swati chande
• ZFS prefetch considered evil?
  • From: Yaroslav Tykhiy
• Compiling using Visual Studio 2005
  • From: Vikram Patil
• End of updates info
  • From: Chris Velevitch
• Re: Problem search on text arrays, using the overlaps (&&) operator
  • From: John Cheng
• Re: Sugestion a db modele like mysql workbrench
  • From: Andreas Wenk
• Re: Passing a table to function
  • From: Merlin Moncure
• Re: Trying to find a low-cost program for Data migration and ETL
  • From: Scott Mead
• Re: Trying to find a low-cost program for Data migration and ETL
  • From: Scott Mead
• Re: howto determine rows count to be returned by DECLARE ... SELECT ...
  • From: Richard Huxton
• Re: Passing a table to function
  • From: Richard Huxton
• Re: Sugestion a db modele like mysql workbrench
  • From: Thomas Kellerer
• Re: Trying to find a low-cost program for Data migration and ETL
  • From: Richard Huxton
• Trying to find a low-cost program for Data migration and ETL
  • From: Rstat
• Re: Feistel cipher, shorter string and hex to int
  • From: Daniel Verite
• Re: Table Partitioning : Having child tables in multiple database servers
  • From: Dimitri Fontaine
• Re: combine multiple row values in to one row
  • From: David Fetter
• Re: Table Partitioning : Having child tables in multiple database servers
  • From: Ransika de Silva
• Re: combine multiple row values in to one row
  • From: David Fetter
• Table Partitioning : Having child tables in multiple database servers
  • From: Ransika de Silva
• Re: Bug in ecpg lib ?
  • From: Albe Laurenz
• Re: Sugestion a db modele like mysql workbrench
  • From: Andreas Wenk
• Re: Normalize INTERVAL ouput format in a db driver
  • From: Sebastien FLAESCH
• Re: Feistel cipher, shorter string and hex to int
  • From: Ivan Sergio Borgonovo
• Re: combine multiple row values in to one row
  • From: Hartman, Matthew
• Re: Sugestion a db modele like mysql workbrench
  • From: Pavel Golub
• Re: An example needed for Serializable conflict...
  • From: Andres Freund
• Re: An example needed for Serializable conflict...
  • From: durumdara
• Re: Feistel cipher, shorter string and hex to int
  • From: Daniel Verite
• Re: An example needed for Serializable conflict...
  • From: Albe Laurenz
• Re: Efficiently move data from one table to another, with FK constraints?
  • From: Albe Laurenz
• Re: Out of memory error
  • From: Mark Cave-Ayland
• Re: Feistel cipher, shorter string and hex to int
  • From: Daniel Verite
• Re: Normalize INTERVAL ouput format in a db driver
  • From: Albe Laurenz
• Sugestion a db modele like mysql workbrench
  • From: Andreas Wenk
• Re: Performance problem with low correlation data
  • From: Scara Maccai
• Re: Out of memory error
  • From: Paul Smith
• Re: Out of memory error
  • From: Paul Ramsey
• Re: combine multiple row values in to one row
  • From: Ivan Sergio Borgonovo
• Re: Problem search on text arrays, using the overlaps (&&) operator
  • From: John Cheng
• combine multiple row values in to one row
  • From: Lee Harr
• Re: Out of memory error
  • From: Paul Smith
• Re: Out of memory error
  • From: Tom Lane
• Efficiently move data from one table to another, with FK constraints?
  • From: Rob W
• Re: Windows installer for pg-8.4 confusion
  • From: Bruce Momjian
• Out of memory error
  • From: Paul Smith
• Re: Schema search_path and $user
  • From: Postgres User
• Re: Schema search_path and $user
  • From: Tom Lane
• Schema search_path and $user
  • From: Postgres User
• Re: Added parameter for CREATE ROLE
  • From: Raymond O'Donnell
• Added parameter for CREATE ROLE
  • From: Michael Gould
• Re: Performance problem with low correlation data
  • From: Greg Stark
• Re: Windows installer for pg-8.4 confusion
  • From: Dave Page
• Re: Windows installer for pg-8.4 confusion
  • From: Stuart McGraw
• Performance problem with low correlation data
  • From: Scara Maccai
• Re: Windows installer for pg-8.4 confusion
  • From: Andreas Wenk
• Windows installer for pg-8.4 confusion
  • From: Stuart McGraw
• Feistel cipher, shorter string and hex to int
  • From: Ivan Sergio Borgonovo
• Re: Problem search on text arrays, using the overlaps (&&) operator
  • From: nha
• Re: Upgrading 8.3 to 8.4 on Windows.
  • From: Tguru
• Re: Postgres 8.3.7 Server Crash: failed to add item to the right sibling in index
  • From: Tom Lane
• Re: COALESCE not filtering well.
  • From: Greg Stark
• Re: Normalize INTERVAL ouput format in a db driver
  • From: Sebastien FLAESCH
• Re: Postgres Plus Advanced Server and general Postgres compatibility?
  • From: Abbas
• COALESCE not filtering well.
  • From: Mohan Raj B
• Passing a table to function
  • From: sqlguru
• Normalize INTERVAL ouput format in a db driver
  • From: Sebastien FLAESCH
• Re: Documentation - PgAdmin
  • From: Dave Page
• howto determine rows count to be returned by DECLARE ... SELECT ...
  • From: Konstantin Izmailov
• Re: Documentation - PgAdmin
  • From: Guillaume Lelarge
• Re: LIKE problem
  • From: A. Kretschmer
• Re: LIKE problem
  • From: Pavel Stehule
• Postgres 8.3.7 Server Crash: failed to add item to the right sibling in index
  • From: CM J
• LIKE problem
  • From: Juan Pablo Cook
• GISVM Server pre-release available
  • From: Ricardo Pinho
• Re: Documentation - PgAdmin
  • From: Guillaume Lelarge
• Re: Documentation - PgAdmin
  • From: Sachin Srivastava
• Re: Documentation - PgAdmin
  • From: Raymond O'Donnell
• Re: Documentation - PgAdmin
  • From: Justin Graf
• Re: Will there be an official pg_migrator release?
  • From: Thomas Kellerer
• Re: How to use RETURN TABLE in Postgres 8.4
  • From: Michal Szymanski
• Example of full text search ranking function somewhere?
  • From: Joost Kraaijeveld
• Postgres Plus Advanced Server and general Postgres compatibility?
  • From: Andre Lopes
• Re: multiple rows by date using count(*)
  • From: Alban Hertroys
• Re: multiple rows by date using count(*)
  • From: Andreas Kretschmer
• Re: Documentation - PgAdmin
  • From: Raymond O'Donnell
• multiple rows by date using count(*)
  • From: Shad Keene
• Re: Will there be an official pg_migrator release?
  • From: Bruce Momjian
• Re: Documentation - PgAdmin
  • From: justin
• Re: Pls help
  • From: justin
• Will there be an official pg_migrator release?
  • From: Thomas Kellerer
• Documentation - PgAdmin
  • From: db . subscriptions
• Function Issue and casting
  • From: Juan Pablo Cook
• Re: Function Issue and casting
  • From: Adrian Klaver
• Function Issue and casting
  • From: Juan Pablo Cook
• Re: Installing plpython on 8.4
  • From: Peter Eisentraut
• Re: Start automatically a function at startup of postgresql server
  • From: Gurjeet Singh
• about pg_stat_get_db_xact_commit
  • From: abdelhak benmohamed
• Re: REINDEX "is not a btree"
  • From: Craig Ringer
• Re: Group by on %like%
  • From: Jennifer Trey
• Start automatically a function at startup of postgresql server
  • From: dfx@xxxxxx
• Re: Pls help
  • From: Scott Marlowe
• Re: Pls help
  • From: Scott Marlowe
• Re: Pls help
  • From: Pavel Stehule
• Re: Pls help
  • From: Scott Marlowe
• Re: Pls help
  • From: Pavel Stehule
• Re: Pls help
  • From: Scott Marlowe
• Re: Pls help
  • From: Pavel Stehule
• Pls help
  • From: Roseller A. Romanos
• Re: Q: data modeling with inheritance
  • From: David Fetter
• Re: Q: data modeling with inheritance
  • From: Reece Hart
• Re: Q: data modeling with inheritance
  • From: Reece Hart
• Re: Installing plpython on 8.4
  • From: Scott Bailey
• Re: Store derived data or use view?
  • From: Michael Black
• Re: PG_DUMP/RESTORE Would like an explanation of these (non-critical) errors
  • From: ANdreas Wenk
• Re: Store derived data or use view?
  • From: Martin Gainty
• Re: Howto get the contents of mystopwords/dictionary/synonym/thesaurus ?
  • From: ANdreas Wenk
• Re: Q: data modeling with inheritance
  • From: David Fetter
• Re: Store derived data or use view?
  • From: Hartman, Matthew
• Store derived data or use view?
  • From: gvimrc
• Re: How to use RETURN TABLE in Postgres 8.4
  • From: Michael Black
• Re: Group by on %like%
  • From: nha
• Re: How to use RETURN TABLE in Postgres 8.4
  • From: Pavel Stehule
• Re: How to use RETURN TABLE in Postgres 8.4
  • From: Tom Lane
• REINDEX "is not a btree"
  • From: Vanessa Lopez
• How to use RETURN TABLE in Postgres 8.4
  • From: Michal Szymanski
• unsubscribe-pattern-allmatching LISTNAME ALL
  • From: Raul Rojas
• Re: Problem search on text arrays, using the overlaps (&&) operator
  • From: John Cheng
• Re: Delete triggers order in delete cascade (pg 8.3.7).
  • From: Jasen Betts
• Re: Group by on %like%
  • From: Dimitri Fontaine
• Re: Group by on %like%
  • From: Guy Flaherty
• Re: Group by on %like%
  • From: Guy Flaherty
• Re: Vacation reply
  • From: Serge Fonville
• Group by on %like%
  • From: Serge Fonville
• Group by on %like%
  • From: Jennifer Trey
• Howto get the contents of mystopwords/dictionary/synonym/thesaurus ?
  • From: Joost Kraaijeveld
• Re: Problem search on text arrays, using the overlaps (&&) operator
  • From: Andreas Wenk
• Re: Installing plpython on 8.4
  • From: Peter Eisentraut
• Installing plpython on 8.4
  • From: Scott Bailey
• Re: Q: data modeling with inheritance
  • From: Nathan Boley
• Re: simulate multiple primary keys
  • From: Lennin Caro
• Q: data modeling with inheritance
  • From: Reece Hart
• Re: pgAdmin - no_spool
  • From: Simon Riggs
• Re: simulate multiple primary keysx
  • From: Brandon Metcalf
• Re: simulate multiple primary keys
  • From: Bill Moran
• Re: simulate multiple primary keys
  • From: Brandon Metcalf
• Re: pgAdmin - no_spool
  • From: Pedro Doria Meunier
• Re: simulate multiple primary keys
  • From: Hartman, Matthew
• simulate multiple primary keys
  • From: Brandon Metcalf
• PG_DUMP/RESTORE Would like an explanation of these (non-critical) errors
  • From: James B. Byrne
• Re: compiling postgres for 64 bit windows using mingw64
  • From: Tom Lane
• compiling postgres for 64 bit windows using mingw64
  • From: McWilliams, Steven
• Re: pgAdmin - no_spool
  • From: Simon Riggs
• Re: Replication and coding good practices
  • From: Simon Riggs
• Re: Database schema dumper
  • From: Joshua J. Kugler
• Re: Upgrading 8.3 to 8.4 on Windows.
  • From: Richard Huxton
• Re: No password prompt logging into Postgres 8.4
  • From: Bill Moran
• Upgrading 8.3 to 8.4 on Windows.
  • From: Hartman, Matthew
• Re: Replication
  • From: Simon Riggs
• No password prompt logging into Postgres 8.4
  • From: Ben Trewern
• Re: Delete triggers order in delete cascade (pg 8.3.7).
  • From: Michaël Lemaire
• Fwd: High consumns memory
  • From: Anderson Valadares
• Fwd: High consumns memory
  • From: Anderson Valadares
• Re: Delete triggers order in delete cascade (pg 8.3.7).
  • From: Richard Huxton
• Re: Delete triggers order in delete cascade (pg 8.3.7).
  • From: Michaël Lemaire
• Re: Does anyone know of a job scheduler that uses PostgreSQL?
  • From: Reid Thompson
• Re: Delete triggers order in delete cascade (pg 8.3.7).
  • From: Richard Huxton
• Re: 1 Sequence per Row i.e. each customer's first order starts at 1
  • From: Greg Stark
• Delete triggers order in delete cascade (pg 8.3.7).
  • From: Michaël Lemaire
• An example needed for Serializable conflict...
  • From: Durumdara
• Re: 1 Sequence per Row i.e. each customer's first order starts at 1
  • From: Scott Marlowe
• Re: 1 Sequence per Row i.e. each customer's first order starts at 1
  • From: Greg Stark
• Re: The connection closed unexpectedly - C++ and Postgre
  • From: drestajumena
• Re: The connection closed unexpectedly - C++ and Postgre
  • From: Scott Marlowe
• The connection closed unexpectedly - C++ and Postgre
  • From: drestajumena
• Re: Help with installation please...
  • From: Craig Ringer
• R: Does anyone know of a job scheduler that uses PostgreSQL?
  • From: Scara Maccai
• Re: 1 Sequence per Row i.e. each customer's first order starts at 1
  • From: Merrick
• Re: 1 Sequence per Row i.e. each customer's first order starts at 1
  • From: Scott Marlowe
• Re: 1 Sequence per Row i.e. each customer's first order starts at 1
  • From: Scott Marlowe
• Re: Bug in ecpg lib ?
  • From: leif
• Re: 1 Sequence per Row i.e. each customer's first order starts at 1
  • From: Merrick
• Re: 1 Sequence per Row i.e. each customer's first order starts at 1
  • From: Scott Marlowe
• Re: 1 Sequence per Row i.e. each customer's first order starts at 1
  • From: Greg Stark
• Problem search on text arrays, using the overlaps (&&) operator
  • From: John Cheng
• 1 Sequence per Row i.e. each customer's first order starts at 1
  • From: Merrick
• Re: datestyle no effect in 8.3.7
  • From: Bruce Momjian
• Re: Preventing a user to use implicit casts
  • From: Scott Marlowe
• Re: Python client + select = locked resources???
  • From: Erik Jones
• Does anyone know of a job scheduler that uses PostgreSQL?
  • From: Anthony Caduto
• Re: High consumns memory
  • From: Merlin Moncure
• Re: Preventing a user to use implicit casts
  • From: Pavel Stehule
• Re: Preventing a user to use implicit casts
  • From: "Stéphane A. Schildknecht"
• Re: Preventing a user to use implicit casts
  • From: Scott Marlowe
• Preventing a user to use implicit casts
  • From: "Stéphane A. Schildknecht"
• Re: Python client + select = locked resources???
  • From: Scott Mead
• Re: Python client + select = locked resources???
  • From: johnf
• Re: FW: lack in psql console
  • From: Juan Camilo Marín
• Re: Big Delete Consistently Causes a Crash
  • From: Tom Lane
• Re: WAL and master multi-slave replication
  • From: Scot Kreienkamp
• Re: [Fwd: Re: Python client + select = locked resources???]
  • From: durumdara
• Big Delete Consistently Causes a Crash
  • From: Tony Webb
• Re: Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function
  • From: Chris Spotts
• Re: Regex Character-Class
  • From: Henry
• cache reads vs. disk reads
  • From: Gerd König
• Multi - table statistics
  • From: Scara Maccai
• Re: High consumns memory
  • From: Albe Laurenz
• Re: Python client + select = locked resources???
  • From: Scott Marlowe
• Re: [Fwd: Re: Python client + select = locked resources???]
  • From: Craig Ringer
• Re: Postgres online backup and restore
  • From: Scott Mead
• Re: Postgres online backup and restore
  • From: Scott Mead
• Re: BETWEEN not matching on timestamp value
  • From: johnf
• Re:
  • From: Sam Mason
• Re:
  • From: Erik Jones
• Re: Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function
  • From: APseudoUtopia
• Re: another can't connect--solved
  • From: BJ Freeman
• Re:
  • From: Merlin Moncure
• Re:
  • From: David Fetter
• Re: BETWEEN not matching on timestamp value]
  • From: James B. Byrne
• Re: BETWEEN not matching on timestamp value
  • From: Tom Lane
• Re: BETWEEN not matching on timestamp value
  • From: Scott Marlowe
• Re: BETWEEN not matching on timestamp value
  • From: James B. Byrne
• Re: BETWEEN not matching on timestamp value
  • From: Scott Marlowe
• Re: BETWEEN not matching on timestamp value
  • From: Alban Hertroys
• Re: BETWEEN not matching on timestamp value
  • From: Tom Lane
• Re:
  • From: Erik Jones
• BETWEEN not matching on timestamp value
  • From: James B. Byrne
• Re: Help with installation please...
  • From: Alan McKay
• Help with installation please...
  • From: Rosko C.A.
• Re: Postgresql and punycode(IDN)
  • From: Steve Atkins
• Re: another can't connect
  • From: BJ Freeman
• Re: Data corruption (8.2.5 Windows XP)
  • From: Marc Schablewski
• Re: Copying only incremental records to another DB..
  • From: Scott Ribe
• Re: Data corruption (8.2.5 Windows XP)
  • From: Alan Hodgson
• Data corruption (8.2.5 Windows XP)
  • From: regis . boumera
• Re:
  • From: Tom Lane
• Re: Unexpected behaviour of date_part
  • From: Tom Lane
• Postgresql and punycode(IDN)
  • From: Kaloyan Iliev
• Re: High consumns memory
  • From: Anderson Valadares
• Setting up spatial index
  • From: Nathaniel
• Re:
  • From: Waldemar Bergstreiser
• Re: Am I in intransaction or in autocommit mode?
  • From: A. Kretschmer
• Re:
  • From: Greg Stark
• Re:
  • From: Waldemar Bergstreiser
• Re: Am I in intransaction or in autocommit mode?
  • From: durumdara
• pgAdmin - no_spool
  • From: Pedro Doria Meunier
• Re: Python client + select = locked resources???
  • From: durumdara
• Re:
  • From: Scott Marlowe
• Re: Unexpected behaviour of date_part
  • From: Richard Huxton
• Re:
  • From: Waldemar Bergstreiser
• Re: masking the code
  • From: Dave Page
• Re: Regex Character-Class
  • From: Thomas Pundt
• Re: Regex Character-Class
  • From: A. Kretschmer
• Re: Unexpected behaviour of date_part
  • From: Albe Laurenz
• Regex Character-Class
  • From: Henry
• Re: Database schema dumper
  • From: Mirko Sertic
• Re: High consumns memory
  • From: Scott Marlowe
• Re: masking the code
  • From: Greg Stark
• Re: 64 Bit ODBC Drivers for windows
  • From: Justin Graf
• 64 Bit ODBC Drivers for windows
  • From: Andrew Timmins
• High consumns memory
  • From: Anderson Valadares
• Re: Database schema dumper
  • From: felix
• Re: Database schema dumper
  • From: felix
• Re: Database schema dumper
  • From: Scott Marlowe
• Re: Database schema dumper
  • From: Thomas Kellerer
• Database schema dumper
  • From: felix
• Re:
  • From: Merlin Moncure
• Re:
  • From: Scott Marlowe
• [no subject]
  • From: littlesuspense
• Re: partitioning question -- how to guarantee uniqueness across partitions
  • From: Erik Jones
• Re: Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function
  • From: David Kerr
• Re: permissions / ACLs made easier?
  • From: Scott Mead
• permissions / ACLs made easier?
  • From: Jeff Davis
• Re: pasting into psql garbles text
  • From: Scott Mead
• Re: GIN and GiST index - more in depth info
  • From: Markus Wollny
• Re: Python client + select = locked resources???
  • From: Craig Ringer
• Re: Slony-I timezone setting
  • From: Raymond O'Donnell
• GIN and GiST index - more in depth info
  • From: Andreas Wenk
• Re: Slony-I timezone setting
  • From: Pedro Doria Meunier
• Re: Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function
  • From: Lennin Caro
• Re: Slony-I timezone setting
  • From: Tom Lane
• Re: [PERFORM] Terrible Write Performance of a Stored Procedure
  • From: Merlin Moncure
• Re: pasting into psql garbles text
  • From: Merlin Moncure
• Re: pasting into psql garbles text
  • From: Cédric Villemain
• Re: masking the code
  • From: Torsten Zühlsdorff
• Re: masking the code
  • From: Scott Mead
• Re: Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function
  • From: Tguru
• Re: Slony-I timezone setting
  • From: Pedro Doria Meunier
• Re: Replication and coding good practices
  • From: David Fetter
• Re: Free OLAP software for Postgres databas
  • From: Joshua Tolley
• Re: Slony-I timezone setting
  • From: Tom Lane
• Re: another can't connect
  • From: Tom Lane
• Re: masking the code
  • From: Scott Mead
• Re: masking the code
  • From: Jonah H. Harris
• Re: Am I in intransaction or in autocommit mode?
  • From: A. Kretschmer
• Re: masking the code
  • From: Scott Mead
• Am I in intransaction or in autocommit mode?
  • From: durumdara
• Create db with template does not transfer ownership
  • From: Ben Harper
• Re: Replication and coding good practices
  • From: Ivan Sergio Borgonovo
• Slony-I timezone setting
  • From: Pedro Doria Meunier
• Python client + select = locked resources???
  • From: durumdara
• Re: Replication and coding good practices
  • From: Craig Ringer
• Re: Unexpected behaviour of date_part
  • From: Richard Huxton
• Re: possible bug on age() function (8.2.4 , 8.3.6)
  • From: Jasen Betts
• Re: pasting into psql garbles text
  • From: Роман Маширов
• Re: pasting into psql garbles text
  • From: Jasen Betts
• Re: masking the code
  • From: Jasen Betts
• Unexpected behaviour of date_part
  • From: Albe Laurenz
• Re: Free OLAP software for Postgres databas
  • From: Sim Zacks
• Re: Copying only incremental records to another DB..
  • From: Arndt Lehmann
• Copying only incremental records to another DB..
  • From: Phoenix Kiula
• Re: another can't connect
  • From: BJ Freeman
• Re: another can't connect
  • From: Andrej
• Re: another can't connect
  • From: Chris
• Re: another can't connect
  • From: BJ Freeman
• Re: another can't connect
  • From: Chris
• another can't connect
  • From: BJ Freeman
• Re: partitioning question -- how to guarantee uniqueness across partitions
  • From: Arndt Lehmann
• Re: partitioning question -- how to guarantee uniqueness across partitions
  • From: Arndt Lehmann
• Re: partitioning question -- how to guarantee uniqueness across partitions
  • From: Arndt Lehmann
• Re: partitioning question -- how to guarantee uniqueness across partitions
  • From: Whit Armstrong
• Re: partitioning question -- how to guarantee uniqueness across partitions
  • From: Tom Lane
• Re: Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function
  • From: Justin
• Re: horizontal sharding
  • From: mobiledreamers
• partitioning question -- how to guarantee uniqueness across partitions
  • From: Whit Armstrong
• Re: Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function
  • From: APseudoUtopia
• Re: Replication and coding good practices
  • From: David Fetter
• Re: data modeling question
  • From: andy
• Replication and coding good practices
  • From: Ivan Sergio Borgonovo
• Re: Date math
  • From: Guy Flaherty
• Re: horizontal sharding
  • From: Greg Smith
• Re: Date math
  • From: Joe Conway
• Re: Fwd: Date math
  • From: Justin
• Re: Fwd: Date math
  • From: Adam Rich
• Fwd: Date math
  • From: Guy Flaherty
• Re: Free OLAP software for Postgres databas
  • From: Joshua Tolley
• Date math
  • From: Adam Rich
• Re: Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function
  • From: Greg Stark
• Re: [Q] sequence and index name limits in 8.4
  • From: Tom Lane
• Re: [Q] sequence and index name limits in 8.4
  • From: Scott Marlowe
• Re: Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function
  • From: Martin Gainty
• Re: Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function
  • From: justin
• [Q] sequence and index name limits in 8.4
  • From: V S P
• Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function
  • From: APseudoUtopia
• Re: Free OLAP software for Postgres databas
  • From: Scott Marlowe
• Re: Free OLAP software for Postgres databas
  • From: Michal Szymanski
• Re: pasting into psql garbles text
  • From: Tom Lane
• Re: pasting into psql garbles text
  • From: Merlin Moncure
• Re: Free OLAP software for Postgres databas
  • From: Joe Conway
• Re: Free OLAP software for Postgres databas
  • From: Scott Marlowe
• Re: pasting into psql garbles text
  • From: Tom Lane
• Free OLAP software for Postgres databas
  • From: Michal Szymanski
• Re: Optimal values for 500 connections
  • From: David Fetter
• Re: pasting into psql garbles text
  • From: Greg Stark
• Re: pasting into psql garbles text
  • From: Merlin Moncure
• Re: pasting into psql garbles text
  • From: Leif B. Kristensen
• Re: pasting into psql garbles text
  • From: Greg Stark
• pasting into psql garbles text
  • From: Merlin Moncure
• Re: Need suggestions
  • From: Alban Hertroys
• Re: horizontal sharding
  • From: mobiledreamers
• Re: horizontal sharding
  • From: Scott Marlowe
• Re: horizontal sharding
  • From: mobiledreamers
• Re: horizontal sharding
  • From: Scott Marlowe
• Re: horizontal sharding
  • From: Scott Marlowe
• Re: Explaining functions.
  • From: Greg Smith
• Re: horizontal sharding
  • From: mobiledreamers
• Re: horizontal sharding
  • From: John R Pierce
• Re: horizontal sharding
  • From: mobiledreamers
• Re: horizontal sharding
  • From: mobiledreamers
• Re: Replication
  • From: Gerry Reno
• Re: masking the code
  • From: Scott Marlowe
• Re: Replication
  • From: Dimitri Fontaine
• Re: masking the code
  • From: Dimitri Fontaine
• data modeling question
  • From: Brandon Metcalf
• Re: Postgresql 8.3.7 SSL support
  • From: Pedro Doria Meunier
• Re: masking the code
  • From: artacus
• Re: Custom runtime variables
  • From: artacus
• Postgresql 8.3.7 SSL support
  • From: Pedro Doria Meunier
• Re: Optimal values for 500 connections
  • From: Pedro Doria Meunier
• Re: Optimal values for 500 connections
  • From: Scott Marlowe
• Optimal values for 500 connections
  • From: Pedro Doria Meunier
• Re: Problems with postgres online backup - restore
  • From: Gerhard Wiesinger
• Re: Need help using function
  • From: Bob Pawley
• Re: Need help using function
  • From: Jonah H. Harris
• Re: Need help using function
  • From: Bob Pawley
• Re: Need help using function
  • From: John R Pierce
• Need help using function
  • From: Bob Pawley
• Re: masking the code
  • From: David Fetter
• Re: Need suggestions
  • From: Filip Rembiałkowski
• Re: Can't start postgresql 8.3.7
  • From: Tom Lane
• Re: Bug in ecpg lib ?
  • From: leif
• Re: PL/pgSQL EXECUTE quote_ident(), and SQL injection
  • From: Pavel Stehule
• Re: PL/pgSQL EXECUTE quote_ident(), and SQL injection
  • From: Knut P. Lehre
• Re: Trigger Function and backup
  • From: Nishkarsh
• PL/pgSQL EXECUTE quote_ident(), and SQL injection
  • From: Knut P. Lehre
• Re: masking the code
  • From: Massa, Harald Armin
• Re: masking the code
  • From: Pavel Stehule
• Re: Custom runtime variables
  • From: Andreas Kretschmer
• masking the code
  • From: luca . ciciriello
• Re: Custom runtime variables
  • From: Pavel Stehule
• Re: Custom runtime variables
  • From: Scott Bailey
• Re: Can't start postgresql 8.3.7
  • From: Sam Wun
• Can't start postgresql 8.3.7
  • From: Sam Wun
• Re: Problems with postgres online backup - restore
  • From: Richard Huxton
• Re: [JDBC] Postgres 8.3.7 -- EOF on client connection
  • From: CM J
• Re: Problems with postgres online backup - restore
  • From: Gerhard Wiesinger
• Re: Custom runtime variables
  • From: Tom Lane
• Custom runtime variables
  • From: Scott Bailey
• Re planned recovery from a certain transaction
  • From: Chris Spotts
• Re: planned recovery from a certain transaction
  • From: Chris Spotts
• Re: Add Space symbols for TSvector
  • From: Arjen Nienhuis
• Re: planned recovery from a certain transaction
  • From: Greg Stark
• Re: planned recovery from a certain transaction
  • From: Scott Marlowe
• Re: planned recovery from a certain transaction
  • From: Alvaro Herrera
• Schedule up for pgDay San Jose
  • From: Josh Berkus
• Re: Need suggestions
  • From: Jack W
• Re: Problems with postgres online backup - restore
  • From: Richard Huxton
• Re: Need suggestions
  • From: Bill Moran
• Re: Problems with postgres online backup - restore
  • From: Gerhard Wiesinger
• Re: Need suggestions
  • From: Bill Moran
• Need suggestions
  • From: Jack W
• Re: Vacuum on the database versus individual tables.
  • From: Scott Marlowe
• Re: horizontal sharding
  • From: Scott Marlowe
• datestyle no effect in 8.3.7
  • From: johnf
• Re: Vacuum on the database versus individual tables.
  • From: Hartman, Matthew
• Re: Vacuum on the database versus individual tables.
  • From: Tom Lane
• Re: Vacuum on the database versus individual tables.
  • From: Hartman, Matthew
• Re: planned recovery from a certain transaction
  • From: Alan Hodgson
• Re: Vacuum on the database versus individual tables.
  • From: Merlin Moncure
• Re: planned recovery from a certain transaction
  • From: Richard Huxton
• Re: Vacuum on the database versus individual tables.
  • From: Dave Page
• Re: Vacuum on the database versus individual tables.
  • From: Grzegorz Jaśkiewicz
• Re: PG 8.3.7 initdb -E LATIN1 fails on Windows
  • From: Alvaro Herrera
• planned recovery from a certain transaction
  • From: Chris Spotts
• Re: Vacuum on the database versus individual tables.
  • From: Hartman, Matthew
• Re: horizontal sharding
  • From: mobiledreamers
• Re: horizontal sharding
  • From: mobiledreamers
• why the similar query takes so difference time in tsearch2?
  • From: Miao Jiang
• Problems with postgres online backup - restore
  • From: Chris Barnes
• Postgres online backup and restore
  • From: Chris Barnes
• Re: create a table inside a function
  • From: Frank Heikens
• Re: Upgrade
  • From: Pedro Doria Meunier
• Re: create a table inside a function
  • From: Alvaro Herrera
• Re: Vacuum on the database versus individual tables.
  • From: Grzegorz Jaśkiewicz
• Support of multibyte encoding for pg_trgm
  • From: Brian Hirt
• Re: horizontal sharding
  • From: David Fetter
• Re: Fedora 11 where is plpython.so
  • From: Clodoaldo Pinto Neto
• Re: Postgres online backup and restore has errors that are concerning
  • From: Alan Hodgson
• Vacuum on the database versus individual tables.
  • From: Hartman, Matthew
• Fedora 11 where is plpython.so
  • From: Clodoaldo Pinto Neto
• How do I add text to a thread?
  • From: Abraham, Danny
• PG 8.3.7 initdb -E LATIN1 fails on Windows
  • From: Abraham, Danny
• Re: Add Space symbols for TSvector
  • From: Tom Lane
• Postgres online backup and restore has errors that are concerning
  • From: Chris Barnes
• Re: create a table inside a function
  • From: Adrian Klaver
• Re: create a table inside a function
  • From: Alain Roger
• Re: create a table inside a function
  • From: Alain Roger
• Re: create a table inside a function
  • From: hubert depesz lubaczewski
• Re: [BUGS] Integrity check
  • From: Greg Stark
• Re: Upgrade
  • From: Greg Stark
• create a table inside a function
  • From: Alain Roger
• Re: Upgrade
  • From: Guy Flaherty
• Re: Upgrade
  • From: Bill Moran
• Upgrade
  • From: Pedro Doria Meunier
• Re: [JDBC] Postgres 8.3.7 -- EOF on client connection
  • From: Saurabh Dave
• Re: JDBC prepared statements & server-side prepared statements
  • From: Dave Cramer
• Re: Replication
  • From: Jasen Betts
• Re: Add Space symbols for TSvector
  • From: Henk van Lingen
• Re: Add Space symbols for TSvector
  • From: Oleg Bartunov
• Add Space symbols for TSvector
  • From: Henk van Lingen
• Re: Bug in ecpg lib ?
  • From: Albe Laurenz
• Re: 8.4 RC1 on ubuntu 9.04 jaunty, problems after install
  • From: Dave Page
• Re: example of aggregate function for product
  • From: Albe Laurenz
• Re: JDBC prepared statements & server-side prepared statements
  • From: Albe Laurenz
• Re: How can I interpolate psql variables in function bodies?
  • From: J. Greg Davidson
• Re: How can I interpolate psql variables in function bodies? - workaround
  • From: J. Greg Davidson
• Re: Serious JDBC problem
  • From: Tom Lane
• Re: example of aggregate function for product
  • From: Alvaro Herrera
• Re: [BUGS] Integrity check
  • From: Scott Mead
• Re: Replication
  • From: Greg Smith
• Re: 8.4 RC1 on ubuntu 9.04 jaunty, problems after install
  • From: Dragan Sahpaski
• Re: 8.4 RC1 on ubuntu 9.04 jaunty, problems after install
  • From: Dragan Sahpaski
• example of aggregate function for product
  • From: Whit Armstrong
• Re: Replication
  • From: Scott Marlowe
• Re: Replication
  • From: Geoffrey
• Re: A question about inheritance and sequence
  • From: Marko Pahić
• Re: 8.4 RC1 on ubuntu 9.04 jaunty, problems after install
  • From: Dave Page
• Re: Replication
  • From: Joshua D. Drake
• Serious JDBC problem
  • From: Bayless Kirtley
• Re: Replication
  • From: Mike Christensen
• Re: 8.4 RC1 on ubuntu 9.04 jaunty, problems after install
  • From: Dave Page
• Re: fast shutdown
  • From: Scott Marlowe
• Re: just curious
  • From: Emanuel Calvo Franco
• fast shutdown
  • From: Mary Sipple
• Re: WAL and master multi-slave replication
  • From: Scott Marlowe
• Re: Return LEFT JOINed tables when one has no matching column
  • From: Madison Kelly
• Re: WAL and master multi-slave replication
  • From: Alvaro Herrera
• Re: 8.4 RC1 on ubuntu 9.04 jaunty, problems after install
  • From: Jorge Vidal - Disytel
• Re: Return LEFT JOINed tables when one has no matching column
  • From: Harald Fuchs
• Re: WAL and master multi-slave replication
  • From: Eduardo Morras
• 8.4 RC1 on ubuntu 9.04 jaunty, problems after install
  • From: Dragan Sahpaski
• Re: WAL and master multi-slave replication
  • From: Scott Marlowe
• Re: WAL and master multi-slave replication
  • From: Eduardo Morras
• Re: PgDay Athens 2009: Call for Presentations
  • From: Joshua D. Drake
• Re: WAL and master multi-slave replication
  • From: Alvaro Herrera
• WAL and master multi-slave replication
  • From: Eduardo Morras
• Re: Replication
  • From: Thomas Kellerer
• Return LEFT JOINed tables when one has no matching column
  • From: Madison Kelly
• Re: just curious
  • From: Dave Page
• just curious
  • From: Filip Rembiałkowski
• Re: A question about inheritance and sequence
  • From: Joshua Tolley
• Re: A question about inheritance and sequence
  • From: Filip Rembiałkowski
• Bug in ecpg lib ?
  • From: leif
• JDBC prepared statements & server-side prepared statements
  • From: Jack Orenstein
• Re: possible bug on age() function (8.2.4 , 8.3.6)
  • From: Philippe Amelant
• Re: possible bug on age() function (8.2.4 , 8.3.6)
  • From: Jasen Betts
• Postgres 8.3.7 -- EOF on client connection
  • From: CM J
• Re: Inserting Values into Interval
  • From: Jasen Betts
• A question about inheritance and sequence
  • From: Marko Pahić
• Re: help with data recovery from injected UPDATE
  • From: Gus Gutoski
• Re: [BUGS] Integrity check
  • From: Albe Laurenz
• Re: Separating raise notice lines
  • From: Alban Hertroys
• Re: Replication
  • From: Dimitri Fontaine
• Re: possible bug on age() function (8.2.4 , 8.3.6)
  • From: Philippe Amelant
• Re: question about frequency of updates/reads
  • From: Craig Ringer
• Re: after vacuum analyze, explain still wrong
  • From: Sim Zacks
• Re: question about frequency of updates/reads
  • From: David Wilson
• Re: question about frequency of updates/reads
  • From: Scott Marlowe
• question about frequency of updates/reads
  • From: Andrew Smith
• PgDay Athens 2009: Call for Presentations
  • From: Michael Alan Brewer
• Re: Replication
  • From: Scott Mead
• Re: Separating raise notice lines
  • From: Craig Ringer
• Re: Replication
  • From: Craig Ringer
• Re: Controlling proliferation of postgres.exe processes
  • From: Alan Hodgson
• Re: Controlling proliferation of postgres.exe processes
  • From: Greg Stark