Re: [HACKERS] A single escape required for log_filename

2009-01-13 Thread Gregory Williamson
Robert Haas wrote: > > "Joshua D. Drake" writes: > >> When I set it up, it automatically appended the time so I got: > >> postgresql.log.1231878270 > >> That seems a bit, well wrong. If I say I want postgresql.log I should > >> get postgresql.log. > > > > You'd probably reconsider around the tim

Re: [HACKERS] Keeping creation time of objects

2008-09-09 Thread Gregory Williamson
Andrew Dunstan wrote: <...> > > Can someone please give a good, concrete use case for this stuff? "Might > be nice to have" doesn't cut it, I'm afraid. In particular, I'd like to > know why logging statements won't do the trick here. > Please pardon the kibbitzer intrusion ... Informix has t

Re: [HACKERS] Extending varlena

2008-08-18 Thread Gregory Williamson
David Fetter wrote" <...> > > > This'd greatly simplify the > > cleanup-dead-objects problem, and we could avoid addressing the > > permissions problem at all, since regular SQL permissions on the table > > would serve fine. But it's not clear what regular SQL fetch and update > > behaviors shou

Re: [HACKERS] A new take on the foot-gun meme

2008-07-01 Thread Gregory Williamson
In further OT Gregory Stark wrote: > > "Shane Ambler" <[EMAIL PROTECTED]> writes: > > > > > >> Robert Treat wrote: > >> > >> > So is that a "golf club gun"? > > >>> Careful what you wish for > >>> http://www.totallyabsurd.com/12gaugegolfclub.htm > >>> > >> I r

Re: [HACKERS] Creating a VIEW with a POINT column

2008-06-25 Thread Gregory Williamson
Nick wrote: > I have a VIEW that consists of two tables, of which contain a POINT > column. When trying to select from the view I get an error... > > ERROR: could not identify an ordering operator for type point > HINT: Use an explicit ordering operator or modify the query. > > Any suggestions

Re: [HACKERS] [GSoC08]some detail plan of improving hash index

2008-05-20 Thread Gregory Williamson
Greg Smith wrote > On Fri, 16 May 2008, Josh Berkus wrote: > > > For a hard-core benchmark, I'd try EAStress (SpecJAppserver Lite) > > This reminds me...Jignesh had some interesting EAStress results at the > East conference I was curious to try and replicate more publicly one day. > Now that

Re: [HACKERS] 8.3devel slower than 8.2 under read-only load

2007-11-21 Thread Gregory Williamson
FWIW, > > Please do tests of at least 2 minutes duration. A 1.25 second test isn't > enough. Please confirm you have VACUUM ANALYZED each db beforehand. > > Have you checked that the EXPLAIN ANALYZEs are essentially identical > also? Is the data identical on both systems? > I've been running s

Re: [HACKERS] psql show dbsize?

2007-10-31 Thread Gregory Williamson
Sorry for top-posting -- challenged reader. Perhaps a future addition as \L ? This command doesn't seem to be used and could be documented as being subject to permissions and slower. I actually would find this useful, but there are other ways of getting it. But having the option would be nice