Howard Rogers writes:
> I have 10 million rows in a table, with full text index created on one
> of the columns. I submit this query:
> ims=# select count(*) from search_rm
> ims-# where to_tsvector('english', textsearch)
> ims-# @@ to_tsquery('english', 'woman & beach & ball');
> count
> --
I have 10 million rows in a table, with full text index created on one
of the columns. I submit this query:
ims=# select count(*) from search_rm
ims-# where to_tsvector('english', textsearch)
ims-# @@ to_tsquery('english', 'woman & beach & ball');
count
---
646
(1 row)
Time: 107.570 ms
..
Anthony Presley writes:
> Ok, I've written a script to find some of this information when an
> in transaction has been hanging out too long, and then run some
> SQL commands. Since there's a lot there, I've added it to PasteBin:
> http://pastebin.com/TpfKd9Ya
It would help if you'd shown the
On Tue, 2010-07-13 at 17:38 -0400, Tom Lane wrote:
> Anthony Presley writes:
> > Every so often (usually in the early morning), we are seeing an "
> > in transaction" show up. This appears to lock / block other statements
> > from going through, though I'm not sure why. If left unchecked, we end
Le 15/07/2010 16:21, Shoaib Mir a écrit :
> On Thu, Jul 15, 2010 at 10:53 PM, Terry Lee Tucker
> mailto:te...@chosen-ones.org>> wrote:
>
> Greetings:
>
> I occasionally find the need to perform some maintenance on one or
> more of
> thirteen different databases. Typically, due to
My version of PostgreSQL is 8.4.3.
--
View this message in context:
http://old.nabble.com/Incorrect-FTS-results-with-GIN-index-tp29172750p29173652.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
On Thu, Jul 15, 2010 at 2:34 AM, tamanna madaan
wrote:
> Hi All
>
>
>
> I am using postgres-8.1.2 .
>
> And getting this error “cache lookup failed for function 19119”.
>
> Can anyone please let me know what could have gone wrong.
>
> How can a function go missing . And which function
>
> Its tal
On Thu, Jul 15, 2010 at 10:53 PM, Terry Lee Tucker wrote:
> Greetings:
>
> I occasionally find the need to perform some maintenance on one or more of
> thirteen different databases. Typically, due to the interaction between the
> databases, I need to lock down the databases for a short period of t
Hi All
I am using postgres-8.1.2 .
And getting this error "cache lookup failed for function 19119".
Can anyone please let me know what could have gone wrong.
How can a function go missing . And which function
Its talkig about ?? its some postgres's internal function or a user
defined func
I pasted incorrect query in point 5. It should be:
5. MORE DETAILED QUERY WITH INDEX
select keywords from search_tab where
(to_tsvector('german', keywords ) @@ to_tsquery('german', 'eeI:*')) and
(to_tsvector('german', keywords ) @@ to_tsquery('german', 'dd:*'));
Hello,
I was trying to use GIN index, but the results seem be incorrect.
1. QUERY WITHOUT INDEX
select count(*) from search_tab where
(to_tsvector('german', keywords ) @@ to_tsquery('german', 'ee:*')) and
(to_tsvector('german', keywords ) @@ to_tsquery('german', 'dd:*'));
count
---
Greetings:
I occasionally find the need to perform some maintenance on one or more of
thirteen different databases. Typically, due to the interaction between the
databases, I need to lock down the databases for a short period of time so
that no updates are being performed anywhere. I do not wan
On 15/07/10 07:04, ankit kamal wrote:
Hi All
I am using a cluster setup with two nodes in it. Replication between
two nodes is being done through slony.
Postgres version is 8.1.2 and slony version is 1.1.5 .
On Master node an error "CDT FATAL: invalid frontend message type 69"
encountered a
On 15 Jul 2010, at 12:57, Ravi Katkar wrote:
> From: Ravi Katkar
> Sent: Thursday, July 15, 2010 2:45 PM
>
> Hi List ,
>
> I have installed PostgreSQL server in RHEL 5.3. I can able to start the
> database and also able to work on the DB by creating tables etc. When I am
> trying to connect
From: Ravi Katkar
Sent: Thursday, July 15, 2010 2:45 PM
Hi List ,
I have installed PostgreSQL server in RHEL 5.3. I can able to start the
database and also able to work on the DB by creating tables etc. When I am
trying to connect thru ODBC from windows machin
Richard Yen wrote:
> Ah, I see what you mean. If there's no rows to return, then there's no
> coalesce-ing to do...
That's right, /but/ if you use a sub-select, you can achieve
something similar:
| tim=# SELECT COALESCE((SELECT ROUND(EXTRACT(epoch FROM now() - query_start))
| tim(#
Hi all.
I'd like to know how efficient is inheritance when the number of
children gets higher and higher.
I mean both with and without the constraint exclusion.
Will this change with 9.0 or possibly 9.1?
Thanks.
--
Vincenzo Romano
NotOrAnd Information Technologies
NON QVIETIS MARIBVS NAVTA PERI
On 15/07/10 17:55, Alban Hertroys wrote:
> On 15 Jul 2010, at 3:05, Craig Ringer wrote:
>
>> It was an example of how it'd be nice to avoid the need for a join when
>> dealing with scalar values. I'd love to be able to write:
>>
>> WITH aconstant AS (1)
>> SELECT x.*, aconstant FROM generate_serie
On 15 Jul 2010, at 3:05, Craig Ringer wrote:
> It was an example of how it'd be nice to avoid the need for a join when
> dealing with scalar values. I'd love to be able to write:
>
> WITH aconstant AS (1)
> SELECT x.*, aconstant FROM generate_series(1,10) AS x;
>
> ... but can't presently do so
On 15/07/10 16:05, Davor J. wrote:
> It seems no secret that a child table will not fire a trigger defined on
> it's parent table. Various posts comment on this. But nowhere could I find a
> reason for this.
[snip]
> I read in the change logs of 8.4: "Force child tables to inherit CHECK
> cons
On Thu, Jul 15, 2010 at 1:04 AM, Andrew Bartley wrote:
> Thanks to all that replied,
> I used Joe Conway's suggestion, using grep and an extracted list of tables,
> functions and views form the DB. It worked very well.
>
> I will attach the code I used to this thread once complete.
> Again Thanks
It seems no secret that a child table will not fire a trigger defined on
it's parent table. Various posts comment on this. But nowhere could I find a
reason for this.
Now, I just wonder whether the people who request this are wrong in their
assumption that a trigger should fire on the child tab
I couldn't resist... http://bit.ly/aks7og
23 matches
Mail list logo
