Re: [PERFORM] Query not using Index

Hi Andreas, The tablespace is not on SSD although I intend to do it within the next week. I actually tried reducing the random_page_cost to 0.2 but it doesn't help. On 26 March 2016 at 22:13, Andreas Kretschmer <akretsch...@spamfence.net> wrote: > Wei Shan <weishan@gmai

[PERFORM] Query not using Index

r3_idx (cost=0.00..2273555.47 rows=71863412 width=0) (actual time=15503.465..15503.465 r ows=71412687 loops=1) Index Cond: (nodeid = 'eleanor3'::text) Total runtime: 388294.378 ms (7 rows) Thanks! -- Regards, Ang Wei Shan

Re: [PERFORM] Multi processor server overloads occationally with system process while running postgresql-9.4

Are you using any connection pooler in front of the database? On 3 Oct 2015 17:04, "Gavin Flower" wrote: > On 03/10/15 21:39, ajaykbs wrote: > >> I am working in a public company who uses only open source applications >> and databases. I have a problem with our

Re: [PERFORM] Server slowing down over time

ostgreSQL 9.3.5, compiled by Visual C++ build 1600, 64-bit > > Windows 2008R2 (64 bits) > > 10 Go RAM > > 4 vCPU > > > > Host : VMWare ESXi 5.5.0 build-2068190 > > CPU Intel XEON X5690 3.97GHz > > HDD 3x Nearline SAS 15K RAID0 > > > > Please let me know if any other information may be useful. > > > Jean Cavallo > > > > > > Having 4 CPUs, I’d try to decrease number of connections from ~20 to 8, > and see if “slowing down” still happens. > > > > Regards, > > Igor Neyman > > > -- Regards, Ang Wei Shan

Re: [PERFORM] problem with select *

'. Kindly tell me where it is going wrong. I have 6MB cache, 1.6GHz CPU, linux 14.04 OS, 8GB RAM. Thanks. -- Regards, Ang Wei Shan

Re: [PERFORM] autofreeze/vacuuming - avoiding the random performance hit

-- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance -- Regards, Ang Wei Shan

Re: [PERFORM] New server: SSD/RAID recommendations?

Hi Graeme, Why would you think that you don't need RAID for ZFS? Reason I'm asking if because we are moving to ZFS on FreeBSD for our future projects. Regards, Wei Shan On 8 July 2015 at 00:46, Graeme B. Bell graeme.b...@nibio.no wrote: RAID controllers are completely unnecessary for SSD

Re: [PERFORM] Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL

Just looking at the 2 B_2 queries, I'm curious as to why is the execution plan different between the 2 machines. Is the optimiser stats updated on both databases? Regards, Wei Shan On 1 April 2015 at 22:32, Aidan Van Dyk ai...@highrise.ca wrote: On Wed, Apr 1, 2015 at 9:56 AM, Pietro Pugni