Re: [GENERAL] Migrating data from DB2 zOS to PostgreSQL

Please, file these as issues on github (i'm the author). It will be much easier to solve your problems. Regards On 06/12/2016 11:42, Sameer Kumar wrote: > > > On Tue, 6 Dec 2016, 9:27 p.m. Swapnil Vaze, > wrote: > > > Hello Julien, > > We created DDLs fr

[GENERAL] different behaviour between select and delete when constraint_exclusion = partition

Hi, I don't know if what's below is a bug or simply not implemented. And I don't really know if, when in doubt, like now, I'd rather pollute general or bugs :) Anyway here is the problem : when using constraint_exclusion=partition, a delete query scans all partitions, when the same query rewrit

Re: [GENERAL] Hope for a new PostgreSQL era?

Le Thu, 8 Dec 2011 12:27:22 +, Simon Riggs a écrit : > On Thu, Dec 8, 2011 at 11:24 AM, Craig Ringer > wrote: > > > Areas in which Pg seems significantly less capable include: > > Please can you explain the features Oracle has in these area, I'm not > clear. Thanks. Maybe I can answer fro

Re: [GENERAL] Hope for a new PostgreSQL era?

Le Thu, 8 Dec 2011 09:29:28 -0600, Merlin Moncure a écrit : > On Thu, Dec 8, 2011 at 9:11 AM, Marc Cousin > wrote: > > Le Thu, 8 Dec 2011 12:27:22 +, > > Simon Riggs a écrit : > > > >> On Thu, Dec 8, 2011 at 11:24 AM, Craig Ringer > >>

Re: [GENERAL] Hope for a new PostgreSQL era?

Le Thu, 8 Dec 2011 16:27:56 +, "Nicholson, Brad (Toronto, ON, CA)" a écrit : > On Thu, Dec 8, 2011 at 9:11 AM, Marc Cousin > > > wrote: > > > > I wish it was the same (I use and like both pgbouncer and pgpool > > too, and they do a good job, I'

Re: [GENERAL] Hope for a new PostgreSQL era?

Le Thu, 8 Dec 2011 17:54:20 +0100, "Tomas Vondra" a écrit : > On 8 Prosinec 2011, 16:11, Marc Cousin wrote: > >> > - admission control, queuing and resource limiting to optimally > >> > load a machine. Some limited level is possible with external > >&

Re: [GENERAL] Hope for a new PostgreSQL era?

Le Thu, 8 Dec 2011 18:02:51 +0100, "Tomas Vondra" a écrit : > On 8 Prosinec 2011, 17:11, Marc Cousin wrote: > > Le Thu, 8 Dec 2011 09:29:28 -0600, > >> >> > - admission control, queuing and resource limiting to > >> >> > optima

Re: [GENERAL] Hope for a new PostgreSQL era?

Le Thu, 8 Dec 2011 10:56:39 -0600, Merlin Moncure a écrit : > On Thu, Dec 8, 2011 at 10:11 AM, Marc Cousin > wrote: > > Le Thu, 8 Dec 2011 09:29:28 -0600, > > Merlin Moncure a écrit : > > > >> On Thu, Dec 8, 2011 at 9:11 AM, Marc Cousin > >> wrote

Re: [GENERAL] Hope for a new PostgreSQL era?

On Thursday 08 December 2011 18:34:35 Tomas Vondra wrote: > On 8 Prosinec 2011, 18:14, Marc Cousin wrote: > >> > It means you keep your session variables, your prepared > >> > statements, > >> > your running transaction, etc… in each individual sessi

Re: [GENERAL] Hope for a new PostgreSQL era?

Le Fri, 09 Dec 2011 11:11:12 +0800, Craig Ringer a écrit : > On 12/08/2011 08:27 PM, Simon Riggs wrote: > > On Thu, Dec 8, 2011 at 11:24 AM, Craig > > Ringer wrote: > > > >> Areas in which Pg seems significantly less capable include: > > Please can you explain the features Oracle has in these ar

Re: [GENERAL] Setting max_fsm_pages

As we're talking about fsm, I've got a question I've been asking myself for some time : If a cluster is restarted, is the fsm forgotten ? (so does it mean one should run a vacuum as soon as the database is restarted ?) Le Dimanche 06 Novembre 2005 03:44, Carlos Oliva a écrit : > Should I set the

Re: [GENERAL] default_index_tablespace?

Yeah, I could use that too :) I think that would be good in order to separate users on different disks easily (if this parameter could be set by user too ...) Le Jeudi 01 Décembre 2005 08:32, Alexander M. Pravking a écrit : > PostgreSQL 8.0 brought a great tablespaces feature. However, it's still