On Sun, Aug 23, 2009 at 4:40 AM, Greg Stark wrote:
> On Sun, Aug 23, 2009 at 4:06 AM, Jeff Ross wrote:
>> Greg Stark wrote:
>
> Yeah, that's a problem. Would you be able to load the pageinspect
> contrib module and run a query?
>
> select (h).* from (select
> heap_page_items(get_raw_page('pg_namesp
If i strip all html tags and filter more stop words, will the search
be more accurate? Actually my fulltext stats returns some like: font
from tags i guess, and other garbage.
If i do that, will i improve the speed of my search?
Thanks!
Ps: I cannot use other tools like MNOsearch, lucene, etc..
On Sun, Aug 23, 2009 at 4:06 AM, Jeff Ross wrote:
> Greg Stark wrote:
>> Actually, I wonder if this isn't more likely to show the problem -- it
>> would explain why *all* your tables are showing up with duplicates
>> rather than just one.
>>
>> select xmin,xmax,ctid,oid,* from pg_namespace
>
> htt
Greg Stark wrote:
On Sat, Aug 22, 2009 at 9:31 PM, Jeff Ross wrote:
I browsed through the system catalogs but haven't found anything yet that
can shine some light on this.
Actually, I wonder if this isn't more likely to show the problem -- it
would explain why *all* your tables are sho
Greg Stark wrote:
On Sat, Aug 22, 2009 at 9:31 PM, Jeff Ross wrote:
Hi,
I recently upgraded to 8.4 and everything went great. �All databases are
working as they are supposed to, no problems seen.
Today, however, I did a \d on a database and was surprised to see sets of 5
identical table ent
On Sun, Aug 23, 2009 at 1:30 AM, John DeSoi wrote:
> While it avoids the sort of my method, it appears to be almost 5 times
> slower (about 4000 keys in the cursor, Postgres 8.4.0):
>
>
> Function Scan on cursor_pk arr (cost=0.00..116011.72 rows=1000 width=4)
> (actual time=13.561..249.916 rows=43
On Sat, Aug 22, 2009 at 9:31 PM, Jeff Ross wrote:
> I browsed through the system catalogs but haven't found anything yet that
> can shine some light on this.
Actually, I wonder if this isn't more likely to show the problem -- it
would explain why *all* your tables are showing up with duplicates
ra
On Sat, Aug 22, 2009 at 9:31 PM, Jeff Ross wrote:
> Hi,
>
> I recently upgraded to 8.4 and everything went great. All databases are
> working as they are supposed to, no problems seen.
>
> Today, however, I did a \d on a database and was surprised to see sets of 5
> identical table entries for eac
On Aug 21, 2009, at 9:22 AM, Greg Stark wrote:
Of course immediately upon hitting send I did think of a way:
SELECT (r).*
FROM (SELECT (SELECT x FROM x WHERE a=id) AS r
FROM unnest(array[1,2]) AS arr(id)
) AS subq;
Thanks to all for the interesting insights and discussion. Wh
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
>> Is there a way to disconnect all the clients as if the server has
>> crashed? It should look like a real crash from the client's point of
>> view.
> ifconfig ethx d
On Sat, Aug 22, 2009 at 01:03:43PM -0700, Sergey Samokhin wrote:
> Is there a way to disconnect all the clients as if the server has
> crashed? It should look like a real crash from the client's point of
> view.
ifconfig ethx down ?
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
Hi,
I recently upgraded to 8.4 and everything went great. All databases are
working as they are supposed to, no problems seen.
Today, however, I did a \d on a database and was surprised to see sets
of 5 identical table entries for each one that is supposed to be there.
Here's the databases
Hello!
To make my client application tolerant of PostgreSQL failures I first
need to be able to simulate them in a safe manner (hard reset isn't a
solution I'm looking for :)
Is there a way to disconnect all the clients as if the server has
crashed? It should look like a real crash from the clien
Nathan Jahnke wrote:
> thanks for your help. unfortunately i'm still getting corruption on
> this particular data (available at
> http://nate.quandra.org/data.bin.0.702601051229191 ) even with these
> changes:
>
> # ./bytea.pl
> Argument "DBD::Pg::PG_BYTEA" isn't numeric in subroutine ent
wrong reply-address; please disregard the last message from me.
thanks for your help. unfortunately i'm still getting corruption on
this particular data (available at
http://nate.quandra.org/data.bin.0.702601051229191 ) even with these
changes:
# ./bytea.pl
Argument "DBD::Pg::PG_BYTEA" isn't num
Nathan Jahnke wrote:
> good catch - it's because i'm used to working in plperlu.
> unfortunately commenting out those lines makes no difference for this
> particular data (that i linked in my original email); it's still
> corrupted:
Don't remove both: remove only the custom decoding.
It'
Hi,
I was going through the list of application at
http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
and was wondering whom I should contact to get my application listed there as well.
It is a Java based SQL tool (http://www.sql-workbench.net) and supports
PostgreSQL (
On 19/08/2009 6:38 PM, Craig Ringer wrote:
Got a virus scanner installed? If so, remove it (do not just disable it) and
see if you can reproduce the problem. Ditto anti-spyware software.
You should also `chkdsk' your file system(s) and use a SMART diagnostic tool to
test your hard disk (assum
On Sat, 2009-08-22 at 00:23 -0700, Jorge Daine Quiambao wrote:
> Craig Ringer,
>
> I tried scanning "slony1_funcs.dll" for dependencies but for some
> reasons it cannot find POSTGRES.EXE, the files is encrypted if I try
> to open it so I can't set the directory. I even tried copying
> POSTGRES.EX
Hi Scott,
I tried doing your suggestion, uninstalling antivirus but it won't work either.
I also tried doing the same in an XP machine but the error is the same.
Thanks!
Jorge
Whoops, I meant if you're on windows, uninstall any antivirus then see
if the problem goes
Craig Ringer,
I tried scanning "slony1_funcs.dll" for dependencies but for some reasons it
cannot find POSTGRES.EXE, the files is encrypted if I try to open it so I can't
set the directory. I even tried copying POSTGRES.EXE in the lib folder where
slony1_funcs.dll resides but of course still g
21 matches
Mail list logo
