If I read the xact_commit field returned by Select * from pg_stat_database
multiple times, and then average the difference between consecutive values,
would this give an approx idea about the transactions per second in my
database?
Does this figure include the number of select statements being
Hello
I need to choose between Intel 320 , Intel 510 and OCZ Vertex 3 SSD's for my
database server. From recent reading in the list and other places, I have
come to understand that OCZ Vertex 3 should not be used, Intel 510 uses a
Marvel controller while Intel 320 had a nasty bug which has been
A few quick thoughts:
1. 320 would be the only SSD I'd trust from your short-list. It's the
only one with proper protection from unexpected power loss.
2. Multiple RAID'ed SSDs sounds like (vast) overkill for your workload.
A single SSD should be sufficient (will get you several thousand TPS
Thanks Greg !
Sorry for delayed response.
We are actually waiting to change the checkpoint_segments in our production
systems (waiting for the downtime).
Thanks
VB
On Wed, Oct 5, 2011 at 11:02 AM, Greg Smith g...@2ndquadrant.com wrote:
On 10/04/2011 07:50 PM, Venkat Balaji wrote:
I was
On Tue, Aug 2, 2011 at 2:22 AM, Jan Wielgus ja...@tlen.pl wrote:
So, there is apparently a problem with vector concatenating - the indexes
don't work then. I tried to use the vectors separately and to make 'OR'
comparison between single vector @@ ts_query checks,
but it didn't help very much
On Mon, Oct 24, 2011 at 11:53 AM, David Boreham david_l...@boreham.org wrote:
A few quick thoughts:
1. 320 would be the only SSD I'd trust from your short-list. It's the only
one with proper protection from unexpected power loss.
yeah.
2. Multiple RAID'ed SSDs sounds like (vast) overkill
On Mon, Oct 24, 2011 at 6:31 PM, Merlin Moncure mmonc...@gmail.com wrote:
2. Multiple RAID'ed SSDs sounds like (vast) overkill for your workload. A
single SSD should be sufficient (will get you several thousand TPS on
pgbench for your DB size).
Also, raid controllers interfere with TRIM.
On 10/24/2011 3:31 PM, Merlin Moncure wrote:
4. Consider using Intel 710 series rather than 320 (pay for them with the
money saved from #3 above). Those devices have much, much higher specified
endurance than the 320s and since your DB is quite small you only need to
buy one of them.
710
On Oct 24, 2011, at 8:16 AM, Venkat Balaji venkat.bal...@verse.in wrote:
Thanks Greg !
Sorry for delayed response.
We are actually waiting to change the checkpoint_segments in our production
systems (waiting for the downtime).
That setting can be changed without downtime.
...Robert
--
On 10/24/2011 4:47 PM, Claudio Freire wrote:
What about redundancy?
How do you swap an about-to-die SSD?
Software RAID-1?
The approach we take is that we use 710 series devices which have
predicted reliability similar to all the other components in the
machine, therefore the unit of
Oh yes.
Thanks a lot Robert !
Regards
VB
On Tue, Oct 25, 2011 at 7:47 AM, Robert Haas robertmh...@gmail.com wrote:
On Oct 24, 2011, at 8:16 AM, Venkat Balaji venkat.bal...@verse.in wrote:
Thanks Greg !
Sorry for delayed response.
We are actually waiting to change the
11 matches
Mail list logo