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
wrote:
> Wei Shan wrote:
>
> > Hi all,
> >
> > Plea
text)
Rows Removed by Index Recheck: 900820
-> Bitmap Index Scan on testdb_nodeid_eleanor3_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
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 critical database which is write
>>
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
ess is getting killed by
> displaying the message 'killed'.
>
> 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
with the housekeeping work.
>
> Graeme Bell
>
>
>
> --
> 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
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 wrote:
> >
> > RAID controllers are completely unnec
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 wrote:
> On Wed, Apr 1, 2015 at 9:56 AM, Pietro Pugni
