Any documentation regarding how to configure postgresql.conf file as per
individual user?
On 21 Mar 2015 13:10, Josh Krupka jkru...@gmail.com wrote:
The other approaches of fixing the estimates, cost params, etc are the
right way of fixing it. *However* if you needed a quick fix for just this
?
Warm Regards,
Vivekanand Joshi
+919654227927
[image: Zeta Interactive]
185 Madison Ave. New York, NY 10016
www.zetainteractive.com
...@comcast.net]
Sent: Thursday, March 19, 2015 12:06 AM
To: vjo...@zetainteractive.com
Cc: Tomas Vondra; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Performance issues
Vivekanand Joshi vjo...@zetainteractive.com writes:
So, here is the first taste of success and which gives me the
confidence
So, here is the first taste of success and which gives me the confidence
that if properly worked out with a good hardware and proper tuning,
PostgreSQL could be a good replacement.
Out of the 9 reports which needs to be migrated in PostgreSQL, 3 are now
running.
Report 4 was giving an issue and
The confusion for me here is that :
I am getting results from the view in around 3 seconds
(S_V_D_CAMPAIGN_HIERARCHY) and 25 seconds (S_V_F_PROMOTION_HISTORY_EMAIL)
But when I am using these two views in the query as the joining tables, it
doesn't give any result. As per my understanding, the
is not
coming out.
Regards,
Vivek
-Original Message-
From: Vivekanand Joshi [mailto:vjo...@zetainteractive.com]
Sent: Tuesday, March 17, 2015 8:40 PM
To: 'Tomas Vondra'; 'pgsql-performance@postgresql.org'
Subject: RE: [PERFORM] Performance issues
The confusion for me here is that :
I am getting
Hi Guys,
Next level of query is following:
If this works, I guess 90% of the problem will be solved.
SELECT
COUNT(DISTINCT TARGET_ID)
FROM
S_V_F_PROMOTION_HISTORY_EMAIL PH
INNER JOIN S_V_D_CAMPAIGN_HIERARCHY CH
EXPLAIN ANALYZE didn't give result even after three hours.
-Original Message-
From: Vivekanand Joshi [mailto:vjo...@zetainteractive.com]
Sent: Tuesday, March 17, 2015 1:11 PM
To: 'Jim Nasby'; 'Tomas Vondra'; 'Scott Marlowe'; 'Varadharajan Mukundan'
Cc: 'pgsql-performance@postgresql.org
-
From: Tomas Vondra [mailto:tomas.von...@2ndquadrant.com]
Sent: Tuesday, March 17, 2015 5:15 PM
To: vjo...@zetainteractive.com; Jim Nasby; Scott Marlowe; Varadharajan
Mukundan
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Performance issues
On 17.3.2015 12:07, Vivekanand Joshi wrote
Attaching explain analyze file as well.
Vivek
-Original Message-
From: Vivekanand Joshi [mailto:vjo...@zetainteractive.com]
Sent: Tuesday, March 17, 2015 5:36 PM
To: 'Tomas Vondra'; 'Jim Nasby'; 'Scott Marlowe'; 'Varadharajan Mukundan'
Cc: 'pgsql-performance@postgresql.org'
Subject: RE
maintenance_work_mem = 700MB
effective_cache_size = 4GB
Sorry, it didn't register when I read it!
(Probably reading too fast)
On Sat, Mar 14, 2015 at 10:06 PM, Gavin Flower
gavinflo...@archidevsys.co.nz wrote:
On 14/03/15 13:12, Tomas Vondra wrote:
On 14.3.2015 00:28, Vivekanand Joshi wrote:
Hi Guys
Hey guys, thanks a lot.
This is really helping. I am learning a lot. BTW, I changed CTE into
subquery and it improved the performance by miles. I am getting the result
in less than 3 seconds, though I am using a 24 GB ram server. It is still a
great turnaround time as compared to previous
I am really worried about the performance of PostgreSQL as we have almost
1.5 billion records in promotion history table. Do you guys really think
PostgreSQL can handle this much load. We have fact tables which are more
than 15 GB in size and we have to make joins with those tables in almost
every
to continue with it.
Having said that, I would day again that I am completely new to this
territory, so I might miss lots and lots of thing.
On 14 Mar 2015 02:07, Tomas Vondra tomas.von...@2ndquadrant.com wrote:
Hi,
On 13.3.2015 20:59, Vivekanand Joshi wrote:
I am really worried about
Hi Guys,
So here is the full information attached as well as in the link provided
below:
http://pgsql.privatepaste.com/41207bea45
I can provide new information as well.
Would like to see if queries of these type can actually run in postgres
server?
If yes, what would be the minimum
are :
Is the query written correctly as per the PostgreSQL?
Am I missing anything here?
Total Memory : 8 GB
shared_buffers = 2GB
work_mem = 64MB
maintenance_work_mem = 700MB
effective_cache_size = 4GB
Any kind of help is appreciated.
Warm Regards,
Vivekanand Joshi
+919654227927
, Mar 13, 2015 at 12:44 PM, Vivekanand Joshi
vjo...@zetainteractive.com wrote:
Hi Team,
I am a novice to this territory. We are trying to migrate few jasper
reports from Netezza to PostgreSQL.
I have one report ready with me but queries are taking too much time. To be
honest, it is not giving
* (Linux 64 bit)
*RAM* : 8 GB
*Storage*: 500 GB
*CPU Cores*: Minimum 4
*RAID*: Level 10
*Disk Type*: SATA
These figures are for POC only.
Does that sound okay? Once again, my trivial questions could be irritating
but this is only a start.
Warm Regards,
Vivekanand Joshi
+919654227927
18 matches
Mail list logo