Re: [PERFORM] DELETE vs TRUNCATE explanation

On Thu, Jul 12, 2012 at 4:21 PM, Harold A. Giménez wrote: > Hi, > > I work with Daniel Farina and was the other engineer who "discovered" this, > once again. That is, I got bit by it and have been running TRUNCATE on my > test suites for years. Hi Daniel and Harold, I don't know if you followed

Re: [PERFORM] Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m

On Thu, Aug 9, 2012 at 4:00 AM, Stefan Keller wrote: > Hi > > 2012/8/8 Jeff Janes : >> On Tue, Aug 7, 2012 at 5:07 PM, Stefan Keller wrote: >>> Hi Craig >>> >>> Clever proposal! >>> I slightly tried to adapt it to the hstore involved. >>> Now I'm having a weird problem that PG says that "relation

Re: [PERFORM] Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m

Hi 2012/8/8 Jeff Janes : > On Tue, Aug 7, 2012 at 5:07 PM, Stefan Keller wrote: >> Hi Craig >> >> Clever proposal! >> I slightly tried to adapt it to the hstore involved. >> Now I'm having a weird problem that PG says that "relation 'p' does not >> exist". >> Why does PG recognize table b in the