[SQL] db benchmarks
does anyone have links to independent benchmarks
just mysql vs postgresql would be cool
the last one that came out was from Great Bridge
has been contested by many {including mysql} i was wondering if anyone
here does have independent benchmarks
id sure appreciate
Re: [SQL] pg_hba.conf
Craig May wrote:
>
> I've renamed the file to "pg_hba.conf". It's owner and groug are now postgres.
> The file is located in /usr/lib/pgsql/. I'm still receiving the same error.
>
if you are running redhat 6.X as i suspect
you should place that file in /var/lib/pgsql
not /usr/lib/pgsql
check /etc/rc.d/init.d/postgresql
to make sure {if you are under redhat}
Re: [SQL] trigger examples
Carolyn Lu Wong wrote: > > I need to write a trigger to create a new record in log table if it's a > new record or if column A and B changes. Can someone give me an example > how to do this. > > Are there any sites that gives trigger examples?? > > Thanks. the fulltextindex in the contrib dir gives an example
Re: [SQL] pg_dump problem
Ed Loehr wrote: > > Graham Vickrage wrote: > > > > I am trying to backup a production database running on v6.5 and restore it > > on our test machine running v6.5. > > > > The largest table has about 750,000 rows, the other 5 tables are very small > > approx 100 rows. > > > > When I try to restore the database using "psql -e database < db.out" I get > > the error message > > "query buffer max length of 16384 exceeded" after each row. > > > > Would somebody please tell me how to increse this buffer (assuming this is > > whats required to solve the problem) as I have looked though the > > documentation and I am still struggling :-( > > You probably don't need to increase the buffer. More likely, there is an > unterminated string constant somewhere in db.out. Yes, that would > probably be a bug in pg_dump, but I do vaguely recall problems in 6.5* > with pg_dump. You might search deja for your error message. > > Regards, > Ed Loehr i seem to remember something about this, if i remeber right i broke out the data and inserted it back in using a perl script using a count loop
[SQL] using a self referencing table
i have a table with this structure name (varchar)|category id (int4)|parent category id (int4)|leaf node (bool) im trying to make a perl script that should tree the info parent cat subcat subcat2 subcat2 subcat subcat2 ... but im having troubles wrapping my head around this im using the Pg modules to access postgres if anyone has any suggestions please lemme know thanks!
Re: [SQL] any proper benchmark scripts?
hello on the modperl list a good thread was happening called 'fast db access' find attached scripts used to do this here are my results: [drfrog]$ perl fast_db.pl postgres 16 wallclock secs ( 0.05 usr + 0.00 sys = 0.05 CPU) @ 400.00/s (n=20) mysql 3 wallclock secs ( 0.07 usr + 0.00 sys = 0.07 CPU) @ 285.71/s (n=20) postgres 17 wallclock secs ( 0.06 usr + 0.00 sys = 0.06 CPU) @ 333.33/s (n=20) mysql 3 wallclock secs ( 0.01 usr + 0.01 sys = 0.02 CPU) @ 1000.00/s (n=20) correct me if im wrong but if fast_db.pl is working right first set is insert second set is select comp stats running stock rpms from mandrake 7.2 for both postgresql and mysql 3.23.23-beta of mysql and 7.02 of postgresql [drfrog@nomad desktop]$ uname -a Linux nomad.localdomain 2.2.18 #2 Tue Apr 17 22:55:04 PDT 2001 i686 unknown [drfrog]$ cat /proc/meminfo total:used:free: shared: buffers: cached: Mem: 257511424 170409984 87101440 24219648 96067584 44507136 Swap: 2549432320 254943232 MemTotal:251476 kB MemFree: 85060 kB MemShared:23652 kB Buffers: 93816 kB Cached: 43464 kB SwapTotal: 248968 kB SwapFree:248968 kB [drfrog]$ cat /proc/cpuinfo processor : 0 vendor_id : AuthenticAMD cpu family : 6 model : 3 model name : AMD Duron(tm) Processor stepping: 1 cpu MHz : 697.535 cache size : 64 KB fdiv_bug: no hlt_bug : no sep_bug : no f00f_bug: no coma_bug: no fpu : yes fpu_exception : yes cpuid level : 1 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 sep mtrr pge mca cmov pat pse36 psn mmxext mmx fxsr 3dnowext 3dnow bogomips: 1392.64 i will recomp both the newest postgresql and mysql not using any optimizing techs at all i'll post the config scripts i use -- back in the day we didn't have no old school -dr. frog http://www.hyperbomb.com it sells itself fast_db.pl benchmark.sql ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[SQL] list of returns types for functions
is there a list of all possible returns for all procedural language types? aka perl can return these types c can return these .. thanks! ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[SQL] help with a function
consider this function: CREATE FUNCTION "test" (integer) RETURNS text AS 'return "select * from testt limit $_[o];";' LANGUAGE 'plperl'; how would i get it to just run the query instead of just return it as text using plperl? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [SQL] plperl
Time Co-Ordinate Tue, 05 Jun 2001 19:45:55 -0400, The Organism labeled Tom Lane said: > clayton cottingham <[EMAIL PROTECTED]> writes: > > how does one execute an sql statement from inside a plperl function? > > At the moment, one doesn't. > > This is one of a number of features that have to be finished before > plperl can be classed as more than a proof-of-concept exercise. > However, Mark Hollomon seems to have lost interest or time to work on > it, and no one else has picked up the ball. Any volunteers out there? > > regards, tom lane > > just looked at the code i wish i could say yes but it looks way beyond my level heres hoping someone pick up the torch ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
