3F
Thanks,
Jacob
On Wed, May 3, 2017 at 7:28 PM, James Sewell
wrote:
> Hi Jacob,
>
> This is the same problem as being able to monitor the total number of
> processed queries, or the total query processing time.
>
> The only solution I'm aware of is to set pg_stat
nformation can't be computed reliably
from pg_stat_statements because of rows being discarded in the face of a
large number of (post normalization/jumble) distinct statements.
Is there a way to retrieve these kinds of statistics in Postgres today?
Thanks,
Jacob
and it worked just fine. Of course not in the
same directory, because that would surely hurt, not due to inotify but
due to how most file systems handles directories with lots of files.
--
Jacob
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
ver/client packages
being installed? Or should I be manually using the morgue as described in
https://www.postgresql.org/message-id/20160731194944.amiwidhsoqh4osac%40msg.df7cb.de
? I feel like I may be missing some key difference between -dev and non
-dev packages.
Thanks,
Jacob
Arg, should have included this in my initial email :-(
9.3.11
On Thu, May 5, 2016 at 7:46 AM, Alvaro Herrera
wrote:
> On Wed, May 04, 2016 at 11:52:47PM -0700, Jacob Scott wrote:
> > Hi,
> >
> > I'm seeing a "tuple concurrently updated" error thrown while e
ay 5, 2016 at 8:13 AM, Alvaro Herrera
wrote:
> Jacob Scott wrote:
> > Arg, should have included this in my initial email :-(
> >
> > 9.3.11
>
> OK. So what are the updates doing? Are there any FKs involved?
>
> --
> Álvaro Herrerahttp://www.2
is error.
- Can a "VACUUM ANALYZE $TABLE" (e.g., from autovacuum) concurrent with
a "UPDATE $TABLE" cause this error?
- Can two concurrent "UPDATE $TABLE" queries which touch completely
disjoint sets of rows (e.g. where clause on primary key with disjoint
filters) cause this error?
Thanks,
Jacob
Hi
A final followup from my side to this post for anyone who may find this
thread in archives in the future.
On the 15th of August Jacob Bunk Nielsen wrote:
> On the 1st of July 2014 Jacob Bunk Nielsen wrote:
>
>> We have a PostgreSQL 9.3.4 running in an LXC container on Debian
&g
SQL in a Linux
container. See this thread for more details:
http://www.postgresql.org/message-id/spamdrop+87ha31kxrc@atom.bunk.cc
We have not solved this problem yet, but currently I'm leaning towards
blaming the container layer, so next time we experience problems I think
we'll try to rem
Hi
On the 1st of July 2014 Jacob Bunk Nielsen wrote:
> We have a PostgreSQL 9.3.4 running in an LXC container on Debian
> Wheezy on a Linux 3.10.43 kernel on a Dell R620 server. Data are
> stored on a XFS file system. We are seeing problems such as:
>
> unexpected data beyond EO
ns in one or more .sql files that you
version control using e.g. git.
Once you have written your functions you can put them in you database
using:
psql -f myfile.sql
--
Jacob
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://w
e backup constrained by CPU (top will show your backup at close to
100% CPU usage) or I/O (top will often show your process in state 'D').
I also like dstat for looking at how things play out in such situations.
Best regards
Jacob
--
Sent via pgsql-general mailing list (pgsql-g
Hi
Jacob Bunk Nielsen writes:
> We have a PostgreSQL 9.3.4 running in an LXC container on Debian
> Wheezy on a Linux 3.10.43 kernel on a Dell R620 server. Data are
> stored on a XFS file system. We are seeing problems such as:
>
> unexpected data beyond EOF in block 2 of relation
c key cryptography is generally slower than using encryption
with symmetric keys, so if we are talking about large amounts of
data that might be a problem.
Perhaps you can tell us why the approaches you have come up with are not
viable to you?
Best regards
Jacob
--
Sent vi
workload that resembles the
workload on the problematic tables, but I can't get that to fail. So
what should be my next step in debugging this?
Best regards
Jacob
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
workload that resembles the
workload on the problematic tables, but I can't get that to fail. So
what should be my next step in debugging this?
Best regards
Jacob
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
stop
5. switch disks (umount/remount at same mountpoint)
6. pg_ctl start
7. pg_stop_backup
This seems like an odd use case because pg_start_backup is designed for
performing on-line backups, but I think it will give me minimum downtime.
Thanks,
Jacob
altogether, but the
results are the same. Am I missing something?
-Jacob
On Wed, 2009-09-30 at 10:17 -0400, Tom Lane wrote:
> Thomas Jacob writes:
> > I've run into some weirdness in PSQL 8.3.8 (Ubuntu 8.04 LTS x86_64
> > package). When I update a row while using a function result
> > that updates that very same row in the "WHERE&qu
Hello List,
I've run into some weirdness in PSQL 8.3.8 (Ubuntu 8.04 LTS x86_64
package). When I update a row while using a function result
that updates that very same row in the "WHERE" part of the update,
the main update no longer takes place, even though the "WHERE"
conditions should match. But
if you used default locations I believe it should be (this is from
memory mind) under c:\program files\postgres\\data\
data is the folder you want.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of ja...@aers.ca
Sent: Thursday, July 09, 2009 1
do the DB folders still exist? if so back them up, reinstall Postgres
(reinstalling XP probably wiped out either DLL's or registry entries)
and relaunch it. don't have it initialize a DB on install
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of
somewhere around 15.
the more I read, the more it seems that mysql speed is a myth. it may
be faster for simple flat-text sort of operations with one or two
concurrent users where the app maintains RI, validates all data, and
handles all of the complex joins. it just doesn't seem to s
you could store the pkey as a md5 or sha1
of the image's data. or any of the other large hashing algorithms.
that way your index only has to compare 32 or 40 bytes instead of kilobytes per
row.
as for the main color, you could generate histogram-like
columns (or even a single column
Martijn van Oosterhout wrote:
On Fri, Jul 21, 2006 at 04:14:52PM +0300, Volkan YAZICI wrote:
On Jul 21 09:02, Jacob Coby wrote:
Volkan YAZICI wrote:
As Tom mentioned, there's support for this feature in the protocol
level, but I don't know any API supports this yet. However, here
Volkan YAZICI wrote:
On Jul 20 08:21, Dan Strömberg wrote:
I would like to know if it is possible to find out the datatypes in the
resultset of a query or a set returning
function without actually executing them ?
As Tom mentioned, there's support for this feature in the protocol
level, but I
badlydrawnbhoy wrote:
Hi all,
I've got a database of URLs, and when inserting new data into it I want
to make sure that there are no functionally equivalent URLs already
present. For example, 'umist.ac.uk' is functionally the same as
'umist.ac.uk/'.
I find that searching for the latter form, us
Tom Lane wrote:
Jacob Coby <[EMAIL PROTECTED]> writes:
I then tried:
foo=# select * from pg_catalog.pg_statistic ;
ERROR: could not access status of transaction 3242180415
DETAIL: could not open file "pg_clog/0C13": No such file or directory
so it seems that pg_catalog.
Tom Lane wrote:
Jacob Coby <[EMAIL PROTECTED]> writes:
I've got a pg 8.1.1 server running autovacuum, and it started attempting
to vacuum template0.
2006-06-22 15:00:50 EDT LOG: autovacuum: processing database "template0"
2006-06-22 15:00:50 EDT ERROR: could
ss as to what I should do.
Thanks,
--
Jacob Coby
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Bill Moran wrote:
On Tue, 06 Jun 2006 09:19:10 -0400
Jacob Coby <[EMAIL PROTECTED]> wrote:
We recently upgraded from php 4.3.10 to 5.1.2, and the %system time has
skyrocketed:
Cpu(s): 42.8% us, 43.6% sy, 0.0% ni, 11.3% id, 2.2% wa, 0.2% hi, 0.0% si
Mem: 8312844k total, 7566168
, 6920384k cached
it used to be around 5% to 10%. The server is a quad-xeon dell pe 6650
running CentOS 4.2 with 8G of RAM running pg 8.1.1.
How can I determine what is causing such high system load? it seems to
have immediately jumped with the php upgrade.
thanks,
--
-Jacob
pt templates and dump
> >them out.
> That is pretty neat! Here is Gavin's script slighty modified with some
> extra features useful to me and maybe to you, too:
Thanks a lot. This is really nice.
--
Cheers,
Jacob Atzen
---(end of broadcast)--
.4.5:
% pg_dumpall -O
pg_dumpall: invalid option -- O
But I'll just use pg_dump where it does exist.
--
Thanks,
Jacob Atzen
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
is
> "PostgreSQL Client Applications" - it covers all the options.
> I'd use pg_dump anyway - unless you have hundreds of databases, it makes
> it easier to keep by backups separate.
I will do that then. Thanks.
--
Cheers,
Jacob Atzen
---(end of
On Fri, Jun 17, 2005 at 01:13:16PM +0100, Raymond O'Donnell wrote:
> On 17 Jun 2005 at 13:52, Jacob Atzen wrote:
> > The second problem is a matter of database ownership. Apparently
> > pg_dumpall will dump the owners of the database along with the data.
> > This is cau
quot;pgsql" but on my local machine the
name is "postgres". How do I get around this? Should I just abandon
pg_dumpall and use pg_dump instead or is there some other way?
--
Thanks,
Jacob Atzen
---(end of broadcast)---
TIP 1: subscri
gards
- Benjamin Jacob.
__
Do you Yahoo!?
The all-new My Yahoo! - Get yours free!
http://my.yahoo.com
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index sc
hallo,
i am using pg7.3.4. i have written a table function in c that tokenizes
a text, returning a setof text. i can use this function either in
constructs like:
select * from tokenize( 'some text that has to be tokenized' );
or in costructs like:
select tokenize( text_field ) from some_tab
sorry, forget this: it was my fault, now the function works also on pg8.
anyway, it is strange that i can do this with c functions and not with
plpgsql ones...
m.
max jacob wrote:
hallo,
i am using pg7.3.4. i have written a table function in c that
tokenizes a text, returning a setof text. i
You should check out Firebird (firebirdsql.sourceforge.net). I believe
your can set databases to be read-only and when embedding, Firebird is
a single DLL.
Jacob
On Mon, 01 Sep 2003 15:42:32 -0400, Christopher Browne
<[EMAIL PROTECTED]> wrote:
>Martha Stewart called it a Good Thi
On Sat, 30 Aug 2003 16:18:14 +0200 (CEST), [EMAIL PROTECTED] (Peter
Eisentraut) wrote:
>many, but it's usually difficult to get customers to agree to this sort of
>thing.
Why is that?
---(end of broadcast)---
TIP 8: explain analyze is your friend
If I do rebuild it with initdb will I still have all my data?
Jacob
-Original Message-
From: Karel Zak [mailto:[EMAIL PROTECTED]]
Sent: 30. august 2001 11:03
To: Tatsuo Ishii
Cc: Jacob Vennervald Madsen; [EMAIL PROTECTED]
Subject: Re: Default encoding in database
On Thu, Aug 30, 2001
ble-locale --enable-unicode-conversion
Can anybody help me?
Best regards,
Jacob Vennervald Madsen
Mobile Systems Developer
GoPinocchio
Norrebrogade 45
DK-2200 Copenhagen
www.gopinocchio.com
+45 26750106
**
This email and any files t
Hi All
Is it possible to fetch data from another database than the current?
E.g. like in Oracle I can select data from 2 different DB's like this:
select * from db1.table1 as tbl1, db2.table2 as tbl2 where tbl1.id1 =
tbl2.id2;
Jacob
---(end of broa
Hi Dim!
I tryed your sujjestion - but no cigar.
I get the same bad results.
Thanks
Jacob
---Dimitri <[EMAIL PROTECTED]> wrote:
>
> Hi, Jacob!
>
> I think you have to declare the cursor AFTER begin transaction.
> I'll be more legal according RDBMS standards.
>
&g
46 matches
Mail list logo
