Re: [PERFORM] View with and without ::text casting performs differently.

2013-09-05 Thread Tom Lane
Brian Fehrle writes: > I have a view, that when created with our create statement works > wonderfully, a query on the view with a standard where clause that > narrows the result to a single row performs in under a single ms. > However, when we export this view and re-import it (dump and restore

Re: [PERFORM] View with and without ::text casting performs differently.

2013-09-05 Thread Brian Fehrle
Apologies, forgot to include Postgres version 9.1.9 - Brian F On 09/05/2013 04:45 PM, Brian Fehrle wrote: Hi All, I have a view, that when created with our create statement works wonderfully, a query on the view with a standard where clause that narrows the result to a single row performs in

[PERFORM] View with and without ::text casting performs differently.

2013-09-05 Thread Brian Fehrle
Hi All, I have a view, that when created with our create statement works wonderfully, a query on the view with a standard where clause that narrows the result to a single row performs in under a single ms. However, when we export this view and re-import it (dump and restore of the database, w

Re: [GENERAL] [PERFORM] Can you please suggest me some links where I can learn:

2013-09-05 Thread Merlin Moncure
On Thu, Sep 5, 2013 at 10:39 AM, Kevin Grittner wrote: > M Tarkeshwar Rao wrote: > >> I want start contributing in Postgres in code level. > > Welcome! You should probably start with this page and its links: > > http://wiki.postgresql.org/wiki/Developer_FAQ > >> Can you please suggest me some li

Re: [PERFORM] COPY TO and VACUUM

2013-09-05 Thread Jeff Janes
On Thu, Sep 5, 2013 at 9:05 AM, Roberto Grandi wrote: > Hi Jeff, > > the proble is that when continously updloading vendors listing on our "big" > table the autovacuum is not able to free space as we would. It might not be able to free it (to be reused) as fast as you need it to, but it should b

Re: [PERFORM] COPY TO and VACUUM

2013-09-05 Thread David Kerr
Hi Roberto, Yes you could partition by vendor and then truncate the partition before loading. Truncate reclaims space immediately and is generally much faster than delete. On Thu, Sep 05, 2013 at 06:05:08PM +0200, Roberto Grandi wrote: - Hi Jeff, - - the proble is that when continously updloa

Re: [PERFORM] COPY TO and VACUUM

2013-09-05 Thread Roberto Grandi
Hi Jeff, the proble is that when continously updloading vendors listing on our "big" table the autovacuum is not able to free space as we would. Secondarly, if we launch a Vacuum after each "upload" we collide with other upload taht are running in parallel. Is it possible, form your point of vi