Tatsuo Ishii writes:
> Just out of curiosity, is there any chance that this kind of query is
> speeding up in 9.1 because of following changes?
> * Allow FULL OUTER JOIN to be implemented as a hash join, and allow
>either side of a LEFT OUTER JOIN or RIGHT OUTER JOIN to be hashed
>
> * Tony Capobianco (tcapobia...@prospectiv.com) wrote:
>> HashAggregate (cost=4391163.81..4391288.05 rows=9939 width=12)
>>-> Hash Join (cost=14.78..4344767.23 rows=9279316 width=12)
>> Hash Cond: (o.emailcampaignid = s.emailcampaignid)
>> -> Seq Scan on openactivity o
On 06/09/2011 07:43 AM, Willy-Bas Loos wrote:
Well, after reading your article i have been reading some materail
about it on the internet, stating that separating indexes from data
for performance benefits is a myth.
I found your comment " So then a single query will only ever access
one of bot
Reuven M. Lerner wrote:
Could this be because we're only doing INSERTs and SELECTs? In such a
case, then we would never reach the threshold of modified tuples that
autovacuum looks for, and thus it would never run. That would, by my
reasoning, mean that we'll never tag dead tuples (which isn'
Jochen Erwied writes:
> Thursday, June 9, 2011, 12:45:06 PM you wrote:
>> As the URL mentions, you can build with CFLAGS=-ffast-math, that
>> should work for PostgreSQL too.
> I just tried this with the source for 9.0.4, at least with this version the
> build will not complete since there is a ch
Hi, everyone. Some people with whom I'm working, and who have an 8.3
system running under Windows, asked me to look into their performance
issues. They have a 1.5 GB database with a few dozen tables, and
500,000 records at most. They said that their system has been running
for a few days, do
Thursday, June 9, 2011, 12:45:06 PM you wrote:
> As the URL mentions, you can build with CFLAGS=-ffast-math, that
> should work for PostgreSQL too.
I just tried this with the source for 9.0.4, at least with this version the
build will not complete since there is a check in
src/backend/utils/adt/d
On Wed, Jun 8, 2011 at 10:57 PM, Greg Smith wrote:
> Samuel Gendler wrote:
>
>> Sure, but if it is a query that is slow enough for a time estimate to be
>> useful, odds are good that stats that are that far out of whack would
>> actually be interesting to whoever is looking at the time estimate,
On Mon, May 16, 2011 at 10:19 AM, Robert Klemme
wrote:
> On Fri, May 13, 2011 at 9:04 PM, Robert Haas
> wrote:
> Separating index and tables might not be a totally good idea
> generally. Richard Foote has an excellent article about Oracle but I
> assume at least a few things do apply to PostgreS
On Thu, Jun 9, 2011 at 13:03, muthu krishnan
wrote:
> Thank you for suggesting the valuable URL, we are getting 3 "floating point
> assist fault" error for every second, will it impact the performance for
> postgresql?
Probably.
The kernel throttles these messages, so you're probably performing
Thursday, June 9, 2011, 12:03:12 PM you wrote:
> Is there any option to turn on "flush to zero mode" in itanium cpu while
> compiling postgresql from source?
configure will complain when specifying './configure CFLAGS=-ffast-math'.
make won't, so a 'make CFLAGS='-O2 -Wall -ffast-math' after doin
Dear Jochen,
Thank you for suggesting the valuable URL, we are getting 3 "floating point
assist fault" error for every second, will it impact the performance for
postgresql?
Is there any option to turn on "flush to zero mode" in itanium cpu while
compiling postgresql from source?
Thank you for y
Thursday, June 9, 2011, 11:20:33 AM you wrote:
> *Jun 9 04:45:42 kernel: postmaster(31965): floating-point assist fault at
> ip 403dad71, isr 0208*
A quick search for 'floating-point assist fault' reveals this article:
http://h21007.www2.hp.com/portal/site/dspp/menuitem.863c
Hi,
We have installed postgresql on itanium server (HP rx7640), only on this
server we are getting the following error in /var/log/messages and also the
postgres performance is very slow.
Error:
*Jun 9 04:45:42 kernel: postmaster(31965): floating-point assist fault at
ip 403dad71, isr 0
On Thu, Jun 9, 2011 at 10:50, muthu krishnan
wrote:
>
> Please guide me how to get only the database user connection (without SQL
> statements) information in logfile.
log_statement = none
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subs
Hi,
We are running postgresql database server on itanium box.
Database - Postgresql 8.3.9
OS - SUSE Linux 11 SP 3
Server - Itanium (ia64)
We are trying to enable user login / logout information in postgresql log
file, to do this we enabled the following in postgresql.conf,
log_connections = on
16 matches
Mail list logo
