timing.
Thanks!
--
Ian Smith
www.ian.org
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
company_pkey on company (cost=0.00..0.27 rows=1
width=4) (actual time=0.006..0.007 rows=1 loops=3555)
Index Cond: (model.company_uid = company.uid)
Total runtime: 41773.972 ms
(33 rows)
--
Ian Smith
www.ian.org
--
Sent via pgsql-performance mailing list (pgsql-performance
Oleg Bartunov wrote:
You didn't provides us any query with explain analyze.
Just to make sure you're fine.
Oleg
On Sun, 22 Jan 2006, [EMAIL PROTECTED] wrote:
Hi folks,
I'm not sure if this is the right place for this but thought I'd
ask. I'm relateively new to postgres having only
Hi folks,
I'm not sure if this is the right place for this but thought I'd ask.
I'm relateively new to postgres having only used it on 3 projects and am
just delving into the setup and admin for the second time.
I decided to try tsearch2 for this project's search requirements but am
having
Guys, just so you know:
OSDL did some testing and found Ext3 to be perhaps the worst FS for
PostgreSQL
-- although this testing was with the default options. Ext3 involved an
almost 40% write performance penalty compared with Ext2, whereas the
penalty
for ReiserFS and JFS was less than
OSDL did some testing and found Ext3 to be perhaps the worst FS for
PostgreSQL
-- although this testing was with the default options. Ext3 involved
an
almost 40% write performance penalty compared with Ext2, whereas the
penalty
for ReiserFS and JFS was less than 10%.
This concurs with
Anyway, with fsync enabled using standard fsync(), I get roughly
300-400
inserts per second. With fsync disabled, I get about 7000 inserts per
second. When I re-enable fsync but use the open_sync option, I can get
about 2500 inserts per second.
You are getting 300-400 inserts/sec with fsync