Re: [PERFORM] pg_dump and thousands of schemas

Here is a sample dump that takes a long time to be written by pg_dump: http://postgresql.1045698.n5.nabble.com/file/n5710183/test.dump.tar.gz test.dump.tar.gz (the file above has 2.4Mb, the dump itself has 66Mb) This database has 2,311 schemas similar to those in my production database. All schem

Re: [PERFORM] Seqscan slowness and stored procedures

Hello 2012/5/26 Ivan Voras : > Hello, > > I have a SQL function (which I've pasted below) and while testing its > code directly (outside a function), this is the "normal", default plan: > > http://explain.depesz.com/s/vfP (67 ms) > > and this is the plain with enable_seqscan turned off: > > http:/

[PERFORM] Seqscan slowness and stored procedures

Hello, I have a SQL function (which I've pasted below) and while testing its code directly (outside a function), this is the "normal", default plan: http://explain.depesz.com/s/vfP (67 ms) and this is the plain with enable_seqscan turned off: http://explain.depesz.com/s/EFP (27 ms) Disabling s