pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPerformance is low Postgres+Solaris
4+ messages / 3 participants
[nested] [flat]
* Performance is low Postgres+Solaris
@ 2008-04-03 11:45 MUNAGALA REDDY <munagalar@yahoo.com>
2008-04-10 23:22 ` Re: Performance is low Postgres+Solaris Reid Thompson <reid.thompson@ateb.com>
2008-04-11 20:26 ` Re: Performance is low Postgres+Solaris Greg Smith <gsmith@gregsmith.com>
0 siblings, 2 replies; 4+ messages in thread
From: MUNAGALA REDDY @ 2008-04-03 11:45 UTC (permalink / raw)
To: pgsql-performance
Hi All,
We are using solaris 10 x86/AMD Opteron and postgresql
8.2 on SunFire X2100 , however performance is very
slow in contrast to linux debian in the same platform.
Is this normal?
Thanks & Regards
Mahi
____________________________________________________________________________________
You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.
http://tc.deals.yahoo.com/tc/blockbuster/text5.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Performance is low Postgres+Solaris
2008-04-03 11:45 Performance is low Postgres+Solaris MUNAGALA REDDY <munagalar@yahoo.com>
@ 2008-04-10 23:22 ` Reid Thompson <reid.thompson@ateb.com>
2008-04-10 23:30 ` Re: Performance is low Postgres+Solaris Reid Thompson <reid.thompson@ateb.com>
1 sibling, 1 reply; 4+ messages in thread
From: Reid Thompson @ 2008-04-10 23:22 UTC (permalink / raw)
To: MUNAGALA REDDY <munagalar@yahoo.com>; +Cc: pgsql-performance
MUNAGALA REDDY wrote:
> Hi All,
>
> We are using solaris 10 x86/AMD Opteron and postgresql
> 8.2 on SunFire X2100 , however performance is very
> slow in contrast to linux debian in the same platform.
> Is this normal?
>
> Thanks & Regards
> Mahi
http://www.google.com/search?q=postgresql+solaris+tuning&ie=utf-8&oe=utf-8&aq=t&rls=...
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Performance is low Postgres+Solaris
2008-04-03 11:45 Performance is low Postgres+Solaris MUNAGALA REDDY <munagalar@yahoo.com>
2008-04-10 23:22 ` Re: Performance is low Postgres+Solaris Reid Thompson <reid.thompson@ateb.com>
@ 2008-04-10 23:30 ` Reid Thompson <reid.thompson@ateb.com>
0 siblings, 0 replies; 4+ messages in thread
From: Reid Thompson @ 2008-04-10 23:30 UTC (permalink / raw)
To: ; +Cc: MUNAGALA REDDY <munagalar@yahoo.com>; pgsql-performance
Reid Thompson wrote:
> MUNAGALA REDDY wrote:
>> Hi All,
>>
>> We are using solaris 10 x86/AMD Opteron and postgresql
>> 8.2 on SunFire X2100 , however performance is very
>> slow in contrast to linux debian in the same platform.
>> Is this normal?
>>
>> Thanks & Regards
>> Mahi
>
> http://www.google.com/search?q=postgresql+solaris+tuning&ie=utf-8&oe=utf-8&aq=t&rls=...
>
>
http://wikis.sun.com/display/DBonSolaris/PostgreSQL
http://www.sun.com/bigadmin/features/articles/postgresql_opensolaris.jsp
http://www.google.fr/search?q=site%3Asun.com+postgresql+tuning&ie=utf-8&oe=utf-8&aq=t&am...
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Performance is low Postgres+Solaris
2008-04-03 11:45 Performance is low Postgres+Solaris MUNAGALA REDDY <munagalar@yahoo.com>
@ 2008-04-11 20:26 ` Greg Smith <gsmith@gregsmith.com>
1 sibling, 0 replies; 4+ messages in thread
From: Greg Smith @ 2008-04-11 20:26 UTC (permalink / raw)
To: MUNAGALA REDDY <munagalar@yahoo.com>; +Cc: pgsql-performance
On Thu, 3 Apr 2008, MUNAGALA REDDY wrote:
> We are using solaris 10 x86/AMD Opteron and postgresql
> 8.2 on SunFire X2100 , however performance is very
> slow in contrast to linux debian in the same platform.
There are some significant differences between how Solaris caches database
files in both of its major filesystems (UFS and ZFS) compared to how Linux
handles caching. Linux is much more aggressive in using lots of memory
effectively for database caching compared to an untuned Solaris 10.
I'd recommend the just published talk at
http://blogs.sun.com/jkshah/entry/postgresql_east_2008_talk_best for an
introduction to the details; the information at pages 8 and 9 there I
found particularly informative.
--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2008-04-11 20:26 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-04-03 11:45 Performance is low Postgres+Solaris MUNAGALA REDDY <munagalar@yahoo.com>
2008-04-10 23:22 ` Reid Thompson <reid.thompson@ateb.com>
2008-04-10 23:30 ` Reid Thompson <reid.thompson@ateb.com>
2008-04-11 20:26 ` Greg Smith <gsmith@gregsmith.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox