[EMAIL PROTECTED] wrote:
If you look at the actual time it's completing very quickly indeed.
So
- it must be something to do with either:
1. Fetching/formatting
the data
2. Transferring the data to the client.
I do agree.
What
happens if you only select half the rows? Does the time to
Hi List,
I have a Query. So when i do explain analyse on it , it shows me many Hash
Joins.
So is it possible to indicate the Query Planner not to consider Hash Join.
--
Regards
Gauri
On 2/24/07, Steinar H. Gunderson [EMAIL PROTECTED] wrote:
Thanks for your time.
GiN version, short:
- Bitmap Heap Scan on tags (cost=8.64..151.79 rows=41 width=0) (actual
time=5.555..30.157 rows=7 loops=1)
Filter: (title % 'foo'::text)
- Bitmap Index Scan on trgm_idx
On Mon, 26 Feb 2007, Guillaume Smet wrote:
On 2/24/07, Steinar H. Gunderson [EMAIL PROTECTED] wrote:
Thanks for your time.
GiN version, short:
- Bitmap Heap Scan on tags (cost=8.64..151.79 rows=41 width=0)
(actual time=5.555..30.157 rows=7 loops=1)
Filter: (title %
On 2/26/07, Oleg Bartunov oleg@sai.msu.su wrote:
Did you rewrite query manually or use rewrite feature of tsearch2 ?
Currently, it's manual. I perform a pg_trgm query for each word of the
search words (a few stop words excluded) and I generate the ts_query
with the similar words instead of
On Mon, 26 Feb 2007, Guillaume Smet wrote:
On 2/26/07, Oleg Bartunov oleg@sai.msu.su wrote:
Did you rewrite query manually or use rewrite feature of tsearch2 ?
Currently, it's manual. I perform a pg_trgm query for each word of the
search words (a few stop words excluded) and I generate the
Hi List,
Machine was down due to some hardware problem.
After then when i issue this command /usr/local/pgsql/bin/psql -l
its giving me the following error
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix
Gauri Kanekar wrote:
Hi List,
Machine was down due to some hardware problem.
After then when i issue this command /usr/local/pgsql/bin/psql -l
its giving me the following error
psql: could not connect to server: No such file or directory
Is the server running locally and
Gauri Kanekar wrote:
Thanks,
But how to start postgres server
On 2/26/07, *Rodrigo Gonzalez* [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
Gauri Kanekar wrote:
Hi List,
Machine was down due to some hardware problem.
After then when i issue this command
Note - try to cc: the mailing list, I don't always read this inbox
Gauri Kanekar wrote:
On 2/26/07, Richard Huxton dev@archonet.com wrote:
Gauri Kanekar wrote:
Hi List,
Machine was down due to some hardware problem.
After then when i issue this command /usr/local/pgsql/bin/psql -l
its
On 26/02/07, Pallav Kalva [EMAIL PROTECTED] wrote:
Hi,
I am in the process of cleaning up one of our big table, this table
has 187 million records and we need to delete around 100 million of them.
I am deleting around 4-5 million of them daily in order to catchup
with vacuum and also
hi!
I've been having some serious performance issues with
postgresql8.2/hibernate/jdbc due to postgres reusing bad cached query
plans. It doesn't look at the parameter values and therefore does not
use any partial indexes.
After trying to set prepareThreshold=0 in the connection string which
Hi all,
I am asking in this list because, at the end of the day, this is a
performance question.
I am looking at writing a search engine of sorts for my database. I
have only ever written very simple search engines before which amounted
to not much more that the query string being used
On Mon, 26 Feb 2007, Gene wrote:
I've been having some serious performance issues with
postgresql8.2/hibernate/jdbc due to postgres reusing bad cached query
plans. It doesn't look at the parameter values and therefore does not
use any partial indexes.
After trying to set prepareThreshold=0
Hello,
I'm trying to make sense of the memory usage reported by 'top', compared
to what pg_database_size shows. Here's one result:
select pg_size_pretty(pg_database_size('production'));
pg_size_pretty
6573 MB
Now, looking at memory use with top, there is a lot memory that
Madison Kelly wrote:
Hi all,
I am asking in this list because, at the end of the day, this is a
performance question.
I am looking at writing a search engine of sorts for my database. I
have only ever written very simple search engines before which amounted
to not much more that the
Mark Stosberg wrote:
Hello,
I'm trying to make sense of the memory usage reported by 'top', compared
to what pg_database_size shows. Here's one result:'
You are missing the most important parts of the equation:
1. What version of PostgreSQL.
2. What operating system -- scratch , I see
On 26-Feb-07, at 11:12 AM, Gene wrote:
hi!
I've been having some serious performance issues with
postgresql8.2/hibernate/jdbc due to postgres reusing bad cached query
plans. It doesn't look at the parameter values and therefore does not
use any partial indexes.
After trying to set
Joshua D. Drake wrote:
Madison Kelly wrote:
Hi all,
I am asking in this list because, at the end of the day, this is a
performance question.
I am looking at writing a search engine of sorts for my database. I
have only ever written very simple search engines before which amounted
to
So I am hoping some of you guys and gals might be able to point me
towards some resources or offer some tips or gotcha's before I get
started on this. I'd really like to come up with a more intelligent
search engine that doesn't take two minutes to return results. :) I
know, in the end
Thank you! setting the protocolVersion=2 works with the newer driver.
I'm still puzzled as to why the prepareThreshold=0 doesn't force the
replan though.
On 2/26/07, Dave Cramer [EMAIL PROTECTED] wrote:
On 26-Feb-07, at 11:12 AM, Gene wrote:
hi!
I've been having some serious performance
Madison Kelly wrote:
I think the more direct question I was trying to get at is How do you
build a 'relavence' search engine? One where results are returned/sorted
by relevance of some sort?. At this point, the best I can think of,
would be to perform multiple queries; first matching the
Mark Stosberg wrote:
Madison Kelly wrote:
I think the more direct question I was trying to get at is How do you
build a 'relavence' search engine? One where results are returned/sorted
by relevance of some sort?. At this point, the best I can think of,
would be to perform multiple queries;
Now see, this is exactly the kind of sagely advice I was hoping for! :)
I'll look into tsearch2, and failing that for some reason, I love the
keyword table idea.
For example keyword search code, you can try this package:
On Mon, 2007-02-26 at 11:29 -0500, Madison Kelly wrote:
I am looking at writing a search engine of sorts for my database. I
have only ever written very simple search engines before which amounted
to not much more that the query string being used with ILIKE on a pile
of columns. This was
At 10:53 AM 2/26/2007, Peter Childs wrote:
On 26/02/07, Pallav Kalva [EMAIL PROTECTED] wrote:
Hi,
I am in the process of cleaning up one of our big table, this table
has 187 million records and we need to delete around 100 million of them.
I am deleting around 4-5 million of them
On Mon, 26 Feb 2007, Madison Kelly wrote:
Hi all,
I'd really like to come up with a more intelligent search engine that doesn't
take two minutes to return results. :) I know, in the end good indexes and
underlying hardware will be important, but a sane as possible query structure
helps to
On Sun, 2007-02-25 at 23:11 +0100, Peter Kovacs wrote:
A related question:
Is it sufficient to disable write cache only on the disk where pg_xlog
is located? Or should write cache be disabled on both disks?
When PostgreSQL does a checkpoint, it thinks the data pages before the
checkpoint
On 2/26/07, Jeff Davis [EMAIL PROTECTED] wrote:
On Sun, 2007-02-25 at 23:11 +0100, Peter Kovacs wrote:
A related question:
Is it sufficient to disable write cache only on the disk where pg_xlog
is located? Or should write cache be disabled on both disks?
When PostgreSQL does a checkpoint,
On Tue, 2007-02-27 at 01:11 +0100, Peter Kovacs wrote:
On 2/26/07, Jeff Davis [EMAIL PROTECTED] wrote:
On Sun, 2007-02-25 at 23:11 +0100, Peter Kovacs wrote:
A related question:
Is it sufficient to disable write cache only on the disk where pg_xlog
is located? Or should write cache be
30 matches
Mail list logo