Andre Felipe Machado wrote:
Postgresql uses around 30% cpu and hard disk heavily (not so as vacuum)
at all executions.
Firebird uses around 40% cpu and hard disk heavily at the first
execution.
The second execution uses around 60% cpu and **NO** disk activity.
The previously cited query running
On Tue, Mar 14, 2006 at 09:02:49AM -0300, andremachado wrote:
> Hello,
> Attached is a file containing the problematic queries cited yesterday, with
> "explain", "\di" and "show all" outputs.
> The first one finished in almost 4 hours. Firebird for windows finished in
> 1m30s.
> The second one CRA
On Fri, Mar 10, 2006 at 10:39:57PM -0300, Andre Felipe Machado wrote:
> It seems that effective_cache_size does not tell postgresql to actually
> use windows disk cache.
No, it just tells PostgreSQL how much cache memory it should expect to
have.
> What parameter must be configured?
> Do you have
On 3/14/06, andremachado <[EMAIL PROTECTED]> wrote:
> Unfortunately, the first query simply returned the same estimated costs by the
> planner.
Can you try making a big increase to work_mem .conf parameter (as much
as is reasonalbe) and see if that helps either query?
ok, thats understandable. yo
Hello,
Many thanks for your suggestions.
I am trying to optimize server configs, as (presumed) my friend already
optimized his queries and firebird windows is executing them fast.
You could see at the new attached file the results of the queries rewrite.
Unfortunately, the first query simply return
On 3/14/06, andremachado <[EMAIL PROTECTED]> wrote:
> Hello,
> Attached is a file containing the problematic queries cited yesterday, with
> "explain", "\di" and "show all" outputs.
> The first one finished in almost 4 hours. Firebird for windows finished in
> 1m30s.
> The second one CRASHED after
Hello,
Attached is a file containing the problematic queries cited yesterday, with
"explain", "\di" and "show all" outputs.
The first one finished in almost 4 hours. Firebird for windows finished in
1m30s.
The second one CRASHED after some hours, without finishing. The error message
is at the file
On Mon, 2006-03-13 at 12:11, andremachado wrote:
> Hello,
> Attached is the text file containing the last rounds of configurations.
> This time, used "show all" just before issuing each relevant "explain analyze"
> to ensure available information.
> Note that the last runs are being executed concur
Andre,
> http://candle.pha.pa.us/main/writings/pgsql/hw_performance/
> brought some light over the subject. For few users, could be a viable
> alternative.
That article is very old. Read this instead:
http://www.powerpostgresql.com/PerfList
> select count(distinct NF.ID_NF ) as contagem, DE.AM_
Hello,
Attached is the text file containing the last rounds of configurations.
This time, used "show all" just before issuing each relevant "explain analyze"
to ensure available information.
Note that the last runs are being executed concurrently with other problematic
query that is consuming 100%
Hello,
I got good results on tuning postgresql performance for my friend.
One of the queries took almost 10 minutes.
Now it completes on 26 miliseconds! (at the second run)
A combination of query otimization, indexes choosing (with some droping
and clustering), server parameters reconfigurations.
Andre Felipe Machado wrote:
It seems that Firebird windows can use adequately as much ram it finds
and postgresql windows can not.
PostgreSQL relies on the OS cache to utilize RAM. Make sure that most of
the RAM is 'available' so Windows can do its thing.
effective_cache_size should be set
I hope tomorrow execute explain with the bitmapscan and seqscan enabled.
bitmapscans are almost always faster?
Like all the rest, they're just a tool, which works great when used in
its intended purpose :
- Fetching just a few percent of the rows from a table is better served
by an in
Andre, Could not Postgresql file cache being killed by firebird activity?Haven´t you tried decrease ramdom_page_cost to 3 or 2?It would be better if only one person will make configuration changes, otherwise it will be difficult to measure each configuration change impact.ReimerAndre Felipe Mac
Hello,
Many thanks for the valuable suggestions and insights.
The defaults enable_bitmapscan and enable_seqscan were altered by my
friend. He already re enabled them (maybe even while I was trying some
of the queries).
The machine is a P4 3.2GHz, 1 GBram, sata hd, windows 2000. I did not
used pg on
Scott Marlowe <[EMAIL PROTECTED]> writes:
> So, do you see any obvious, low hanging fruit here?
It would help if we were being told the whole truth about the settings
being used. The first few plans are clearly suffering from the
"enable_seqscan = off" error, but the last few don't seem to be. I
Scott Marlowe wrote:
> On Tue, 2006-03-07 at 11:15, Alvaro Herrera wrote:
> > Scott Marlowe wrote:
> >
> > > Lastly, I noticed that after you clusters on all your indexes, the query
> > > planner switched from a merge join to a hash join, and it was slower.
> > > You might wanna try turning off h
On Tue, 2006-03-07 at 11:15, Alvaro Herrera wrote:
> Scott Marlowe wrote:
>
> > Lastly, I noticed that after you clusters on all your indexes, the query
> > planner switched from a merge join to a hash join, and it was slower.
> > You might wanna try turning off hash joins for a quick test to see
Scott Marlowe wrote:
> Lastly, I noticed that after you clusters on all your indexes, the query
> planner switched from a merge join to a hash join, and it was slower.
> You might wanna try turning off hash joins for a quick test to see if
> merge joins are any faster.
Anyway please note that cl
On Tue, 2006-03-07 at 10:29, andremachado wrote:
> Hello,
> A friend asked for help to accelerate some postgresql queries on postgresql
> 8.1.2 for windows.
> He is comparing with firebird.
> Firebird was being up to 90 times faster at some queries.
> Attached is a gziped text file containing some
Andre, I noticed that enable_bitmapscan and enable_seqscan are off, is there a reason for it? Have you tried with enable_bitmapscan on? How much RAM do you have? What kind of disks are being used? Beste regards, Reimer 55-47-33270878 Blumenau - SC - Brazil andremachado <[EMAIL PR
andremachado wrote:
Hello,
A friend asked for help to accelerate some postgresql queries on postgresql
8.1.2 for windows.
He is comparing with firebird.
Firebird was being up to 90 times faster at some queries.
Attached is a gziped text file containing some steps I tried on a simple
example query
Hello,
A friend asked for help to accelerate some postgresql queries on postgresql
8.1.2 for windows.
He is comparing with firebird.
Firebird was being up to 90 times faster at some queries.
Attached is a gziped text file containing some steps I tried on a simple
example query.
Could get improvemen
23 matches
Mail list logo
