Re: [GENERAL] The return of the auto-vacuum

On 02/11/2015 07:49 AM, Nestor A. Diaz wrote: Hello Everybody, This is the scenario: I have a postgres 8.4, debian packages installed from pgdg repository and version equal to: 8.4.21-1.pgdg70+1 I have a GPS database that insert about 4 million records on some tables every week, the database

Re: [GENERAL] Prepared statements with bind parameters for DDL

On 02/11/2015 09:42 AM, deepak wrote: Hi, I find that one can't have a prepared statement with bind parameters for a DDL statement, although I couldn't find the rationale for this restriction. Is this limitation due to the database design, or is it something that's imposed by the SQL standard

Re: [GENERAL] Prepared statements with bind parameters for DDL

deepak deepak...@gmail.com writes: I find that one can't have a prepared statement with bind parameters for a DDL statement, Nope. DDL commands generally don't have any support for evaluating expressions, which would be the context in which parameters would be useful. Nor have they got plans,

[GENERAL] Prepared statements with bind parameters for DDL

Hi, I find that one can't have a prepared statement with bind parameters for a DDL statement, although I couldn't find the rationale for this restriction. Is this limitation due to the database design, or is it something that's imposed by the SQL standard and/or the JDBC drivers? Please

Re: [GENERAL] Cluster seems broken after pg_basebackup

On 02/10/2015 08:38 AM, Guillaume Drolet wrote: Adrian, in response to your question: 2015-02-06 07:11:38 EST FATAL: le rôle « 208375PT$ » n'existe pas So where is role 208375PT$ supposed to come from? I found that when I stop/start/restart pgsql through the services.msc application in

[GENERAL] The return of the auto-vacuum

Hello Everybody, This is the scenario: I have a postgres 8.4, debian packages installed from pgdg repository and version equal to: 8.4.21-1.pgdg70+1 I have a GPS database that insert about 4 million records on some tables every week, the database is partitioned per week, I do a manual vacuum

Re: [GENERAL] Prepared statements with bind parameters for DDL

On Wed, Feb 11, 2015 at 02:22:10PM -0500, Tom Lane wrote: deepak deepak...@gmail.com writes: I find that one can't have a prepared statement with bind parameters for a DDL statement, Nope. DDL commands generally don't have any support for evaluating expressions, which would be the

Re: [GENERAL] Hardware requirements for a PostGIS server

Thanks to everyone who contributed to this thread, either on the PostGIS [1] or the PostgreSQL [2] mailing lists. I will try to summarize everything in this message, which I will actually post on both lists to give an update to everyone. I hope it can be useful for other people interested.

Re: [GENERAL] Prepared statements with bind parameters for DDL

Martijn van Oosterhout klep...@svana.org writes: On Wed, Feb 11, 2015 at 02:22:10PM -0500, Tom Lane wrote: Nope. DDL commands generally don't have any support for evaluating expressions, which would be the context in which parameters would be useful. Nor have they got plans, which would be

Re: [GENERAL] Hardware requirements for a PostGIS server

On 12/02/15 12:38, Mathieu Basille wrote: Thanks to everyone who contributed to this thread, either on the PostGIS [1] or the PostgreSQL [2] mailing lists. I will try to summarize everything in this message, which I will actually post on both lists to give an update to everyone. I hope it can

Re: [GENERAL] Hardware requirements for a PostGIS server

On 12/02/15 12:38, Mathieu Basille wrote: [...] [1] Start of the thread here: http://lists.osgeo.org/pipermail/postgis-users/2015-February/040120.html [...] http://lists.osgeo.org/pipermail/postgis-users/2015-February/040134.html [...] * About usage being mostly read: this will be true for