On Sat, Aug 2, 2008 at 5:11 PM, David Fetter <[EMAIL PROTECTED]> wrote:
> On Sat, Aug 02, 2008 at 09:23:31AM +0200, Marco Bizzarri wrote:
>> Hi all.
>>
>> I need to keep a numer of counters in my application; my counters
>> are currently stored in a table:
>>
>> name | next_value | year
>>
>> The c
On Sun, Aug 3, 2008 at 1:40 AM, Berend Tober <[EMAIL PROTECTED]> wrote:
>
>
> The way I understand the documentation at
>
> "http://www.postgresql.org/docs/8.3/static/transaction-iso.html";
>
> and
>
> 'http://www.postgresql.org/docs/current/static/explicit-locking.html',
>
> you should not have to
hi, all:
I use pg_dump command to dump a specified table:
pg_dump mydb -p -Uyahoo -t mytable -D -a > /export/dump.sql
but, I got this:
---
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: missing chunk number 0 for
toast value 14319826
pg_dump: The
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am using postgresql 8.2.7 on gentoo for my dbmail backend.
I am also testing it on mysql 5.
I am trying to figure out if I need to tune my database configuration or
if querying a bytea field is just not practical in postgresql.
Searching with the m
On Aug 3, 2008, at 12:12 PM, Sim Zacks wrote:
This is the query that is used (I know it is not as efficient as it
could be, but this is the query it comes with):
SELECT m.message_idnr,k.messageblk FROM dbmail_messageblks k JOIN
dbmail_physmessage p ON k.physmessage_id = p.id JOIN dbmail_message
On Aug 3, 2008, at 2:36 PM, Sim Zacks wrote:
The LIKE operator is likely the problem, but it is a critical part
of an
email application. Searches are done by, "Show me all emails
containing
the following word."
I've tried using TSearch2's full text index. It made the query 50%
faster, takin
The LIKE operator is likely the problem, but it is a critical part of an
email application. Searches are done by, "Show me all emails containing
the following word."
I've tried using TSearch2's full text index. It made the query 50%
faster, taking 5 minutes. This is still not even close to the les
Sim Zacks <[EMAIL PROTECTED]> writes:
> The explain of the query is:
Could we see EXPLAIN ANALYZE, not EXPLAIN? Without actual facts
to work from, any suggestions would be mere guesswork.
Also, what can you tell us about the sizes of the messageblk
strings (max and avg would be interesting)?
On Sun, Aug 3, 2008 at 1:50 AM, Marco Bizzarri <[EMAIL PROTECTED]> wrote:
> On Sun, Aug 3, 2008 at 1:40 AM, Berend Tober <[EMAIL PROTECTED]> wrote:
>>
>>
>> The way I understand the documentation at
>>
>> "http://www.postgresql.org/docs/8.3/static/transaction-iso.html";
>>
>> and
>>
>> 'http://www.
Hi all,
I installed postgresql-8.3.3-1 for win2000 with UUID-OSSP. Following
the documentation I issued this query:
SELECT uuid_generate_v3(uuid_ns_url(), 'http://www.postgresql.org');
but the DB returns with this error message:
ERROR: function uuid_ns_url() does not exist
SQL state: 42883
Pretty sure the uuid stuff only works in non-windows OSes.
Oh, and next time, use a more descriptive subject line for better /
quicker responses.
On Sun, Aug 3, 2008 at 2:18 PM, <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I installed postgresql-8.3.3-1 for win2000 with UUID-OSSP. Following the
> do
On Aug 3, 2008, at 1:18 PM, [EMAIL PROTECTED] wrote:
ERROR: function uuid_ns_url() does not exist
Remember to install the functions in your database using the SQL file
in the contrib/uuid-ossp directory, uuid-ossp.sql.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
T
Hi.
Sorry, it was not included in release.
please see,
http://winpg.jp/~saito/pg_work/OSSP_win32/
Regards,
Hiroshi Saito
>Hi all,
>
>I installed postgresql-8.3.3-1 for win2000 with UUID-OSSP. Following
>the documentation I issued this query:
>
>SELECT uuid_generate_v3(uuid_ns_url(), 'http://w
I'm trying to demonstrate recovery using the "continuous archiving"
backup technique. I'm using 8.3 on Windows.
I made a base backup while the postgres was running using the following
batch file:
--
psql -d test_database -U user_name -c "SELECT pg_start_backup('test')
Sim Zacks wrote:
(quoting someone:)
That LIKE operator is probably your problem. An unbounded LIKE like that
(with a wildcard on both sides) means no index can be used, hence you
get a sequential scan.
Was the message to which you responded posted to the newsgroup? It isn't
appearing in my n
The [EMAIL PROTECTED] email address is invalid. I tried to send it this email:
If I remember correctly, the news feed is gatewayed off the mailing
list, so it's possible for a message to the list to not appear in the
group if it gets dropped at the gateway. Sorry if this is redundant
info for yo
On 04/08/2008, Lew <[EMAIL PROTECTED]> wrote:
> Was the message to which you responded posted to the newsgroup? It isn't
> appearing in my newsreader.
>
> Who wrote the message you quoted (you failed to cite the source)?
He was quoting Alban Hertroys, and it appeared on the general mailing list
One last thing. I'd rather my emails just get dropped silently if
that's the minimum someone can do. Use a valid email address that
goes to /dev/null and I'll be happy. You may miss a few things sent
directly to you, but since that's not what you want anyway, it's no
big loss, right?
On Sun, Au
On Sun, Aug 3, 2008 at 8:01 PM, Andrej Ricnik-Bay
<[EMAIL PROTECTED]> wrote:
> On 04/08/2008, Lew <[EMAIL PROTECTED]> wrote:
>
>> Was the message to which you responded posted to the newsgroup? It isn't
>> appearing in my newsreader.
>>
>> Who wrote the message you quoted (you failed to cite the
On 04/08/2008, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> One last thing. I'd rather my emails just get dropped silently if
> that's the minimum someone can do. Use a valid email address that
> goes to /dev/null and I'll be happy. You may miss a few things sent
> directly to you, but since th
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I got the response by email, but it was also addressed to the mailing
list. My response was also an email sent to the mailing list, not to the
newsgroup. I got one other response, that I do not see in the newsgroup.
And I will reply to it also using th
Tom Lane wrote:
> Could we see EXPLAIN ANALYZE, not EXPLAIN? Without actual facts
> to work from, any suggestions would be mere guesswork.
This was taken immediately after a vacuum analyze on the database.
"HashAggregate (cost=41596.68..41596.84 rows=16 width=764) (actual
time=488263.802..48826
22 matches
Mail list logo
