Hi List,
I am having trouble trying to figure out
how to get the result listed at the bottom.
I have 3 tables units, types of units which has a description of the units,
and a table that list associations of the units. I can't figure out
how to do the proper joins. Any pointers would be appreciat
On 05/11/2015 07:16 AM, Oliver Elphick wrote:
On Mon, 2015-05-11 at 06:46 -0400, Steve Clark wrote:
Hi List,
I am having trouble trying to figure out
how to get the result listed at the bottom.
I have 3 tables units, types of units which has a description of the units,
and a table that list
Hi List,
I am a noob trying to do something that seems like it should be easy but I
can't figure it out.
I have a table like so:
id | ref_id | sts
--
1 || 0
2 | 1 | 1
3 || 0
4 || 0
5 | 4 | 1
6 || 0
7 | 6 | 1
I want t
Thanks all the below seem to do the trick.
On 06/02/2016 01:58 PM, David G. Johnston wrote:
select max(id) from yourtable where sts=0 and id not in (select ref_id from
yourtable);
select max(id) from yourtable where sts=0 and id not in (select ref_id from
yourtable);
--
Stephen Clark
Hi List,
I am a noob trying to do something that seems like it should be easy but I
can't figure it out.
I have a table like so:
id | ref_id | sts
--
1 || 0
2 | 1 | 1
3 || 0
4 || 0
5 | 4 | 1
6 || 0
7 | 6 | 1
I want t
) from sometable where sts=0
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Steve Clark
Sent: Thursday, June 2, 2016 9:56 AM
To: pgsql
Subject: [GENERAL] dumb question
Hi List,
I am a noob trying to do something that
Hello List,
I am occasionally seeing the following error:
ALERT 3 sqlcode=-400 errmsg=deadlock detected on line 3351
from an application written using ecpg when trying an update to the table.
Can autovacuum be causing this,
since no one else is updating this database table.
Thanks,
--
Stephen
On 10/28/2016 09:15 AM, Adrian Klaver wrote:
On 10/28/2016 05:28 AM, Steve Clark wrote:
Hello List,
I am occasionally seeing the following error:
ALERT 3 sqlcode=-400 errmsg=deadlock detected on line 3351
So what exactly is it doing at line 3351?
from an application written using ecpg when
On 10/28/2016 09:48 AM, Tom Lane wrote:
Steve Clark writes:
No. But I examined the pg_log/log_file and saw an error indicating it was
autovacuum:
2016-10-27 09:47:02 EDT:srm2api:12968:LOG: sending cancel to blocking
autovacuum PID 12874
2016-10-27 09:47:02 EDT:srm2api:12968:DETAIL: Process
On 10/28/2016 10:25 AM, Tom Lane wrote:
Steve Clark writes:
On 10/28/2016 09:48 AM, Tom Lane wrote:
Retrying might be a usable band-aid, but really this is an application
logic error. The code that is trying to do "lock table t_unit in
exclusive mode" must already hold some lower-
Hi
I installed the following package:
postgresql94-server-9.4.9-1PGDG.rhel6.x86_64
postgresql94-plperl-9.4.9-1PGDG.rhel6.x86_64
postgresql94-plpython-9.4.9-1PGDG.rhel6.x86_64
postgresql94-contrib-9.4.9-1PGDG.rhel6.x86_64
postgresql94-devel-9.4.9-1PGDG.rhel6.x86_64
postgresql94-libs-9.4.9-1PGDG.rh
Hi List,
I have the following table that has netflow data. I can get the top ten
receivers by the query below - but I would also like to get
at the same time a grand total of the RX Bytes. I am not exactly sure how to do
it. This is with version 8.4.
select ip_dst as "Receiver" ,sum(bytes) as
Hello List,
I am doing a pg_dumpall -c on 7.4.
I then use psql to load into 8.2 everything seems to be right except my
db user passwords don't work anymore.
What am I missing.
I have already tried starting 8.2 postgres with both
#password_encryption = on
password_encryption = off
then reloadin
Hello List,
the man page for pg_dump say:
pg_dump is a utility for backing up a PostgreSQL database. It makes
consistent backups even if the database is being used
concurrently.
does pg_dumpall make consistent backups if the database is being used
concurrently?
Even though the
Scott Marlowe wrote:
On Jan 17, 2008 10:35 AM, Steve Clark <[EMAIL PROTECTED]> wrote:
Hello List,
I am doing a pg_dumpall -c on 7.4.
I then use psql to load into 8.2 everything seems to be right except my
db user passwords don't work anymore.
What am I missing.
What error mess
Erik Jones wrote:
On Jan 17, 2008, at 1:08 PM, Greg Smith wrote:
On Thu, 17 Jan 2008, Tom Lane wrote:
There isn't any good way to guarantee time coherence of dumps
across two databases.
Whether there's a good way depends on what you're already doing.
If you're going to the trouble of
Bricklen Anderson wrote:
Steve Clark wrote:
function from 7.4.x postgres
CREATE FUNCTION update_dns(text, text) RETURNS integer
AS 'UPDATE domain_details SET domain = $2 WHERE domain = $1;
DELETE from domains where domain = $1;
SELECT 1 AS ignore;'
LANGUAGE sql;
function from 7.4.x postgres
CREATE FUNCTION update_dns(text, text) RETURNS integer
AS 'UPDATE domain_details SET domain = $2 WHERE domain = $1;
DELETE from domains where domain = $1;
SELECT 1 AS ignore;'
LANGUAGE sql;
I load it into 8.2.5 - then dump it out and it is change
Tom Lane wrote:
Steve Clark <[EMAIL PROTECTED]> writes:
explain shows:
Aggregate (cost=4712921585.30..4712921585.31 rows=1 width=0)
-> Seq Scan on t_event_ack_log a (cost=103170.29..4712920878.60
rows=282677 width=0)
Filter: (NOT (subplan))
Daniel Verite wrote:
Steve Clark wrote:
any way i have 2 table - A and B.
each table has a key field and if a row is in B it should have a
corresponding row in A - but theres
the problem it doesn't for all the rows in B.
So I want to do something like
delete from B where key n
Hello List,
this is a noobie question:
I have had to take over an existing system - it was supposed to have
some contraints that
prevented dangling references - but...
any way i have 2 table - A and B.
each table has a key field and if a row is in B it should have a
corresponding row in A -
Tom Lane wrote:
Steve Clark <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
Also, whatever is the ORDER BY for?
without the order by it wants to do a seq scan of t_unit_event_log.
see below:
explain select count(*) from t_event_ack_log where event_log_no not
in (select event_log_n
On 11/01/2010 02:49 PM, Carlos Mennens wrote:
On Mon, Nov 1, 2010 at 2:27 PM, Steve Crawford
wrote:
I'm guessing you are missing an initdb. Move your old data directory
somewhere else for now and do a new initdb so you can start up version 9.
When you say 'old data' can you be more
On 11/04/2010 11:10 AM, Bill Moran wrote:
In response to Michael Gould:
I know that this is probably a "religion" issue but we are looking to move
Postgres to a Linux server. We currently have a Windows 2008 R2 active
directory and all of the other servers are virtualized via VMWare ESXi.
On 11/15/2010 11:00 AM, Scott Ribe wrote:
On Nov 15, 2010, at 8:50 AM, Tom Lane wrote:
netstat will probably work for this, depending on what platform you're on.
OS X. I can see the connections, but I don't see an option to display PIDs.
netstat -an will do it on linux.
sockst
Hello All,
I am working with a postgresql database that has two columns.
One for an ip address and another for the netmask. Both of these
columns are char varying(30). I would like to convert to just
one column as inet. Any one know a slick way to convert the
dotted quad netmask, E.G. 255.255.128
On 12/07/2010 10:30 AM, Jon Nelson wrote:
On Tue, Dec 7, 2010 at 9:17 AM, Steve Clark wrote:
Hello All,
I am working with a postgresql database that has two columns.
One for an ip address and another for the netmask. Both of these
columns are char varying(30). I would like to convert to
On 12/07/2010 11:43 AM, Tom Lane wrote:
Steve Clark writes:
Thanks for the response Jon. I should have stated this PG 8.1.x and '&'
doesn't exist for network functions.
I don't think& does what you want anyway. It just does a bit AND on
the two addr
Help!
This is postgresql 8.1.3 also the database debug can easily be recreated
if I have to drop it
but I can't seem to do that either.
vacuumdb debug
vacuumdb: could not connect to database debug: FATAL: database is not
accepting commands to avoid wraparound data loss in database "debug"
H
On 12/14/2010 01:04 PM, Steve Clark wrote:
Help!
This is postgresql 8.1.3 also the database debug can easily be
recreated if I have to drop it
but I can't seem to do that either.
vacuumdb debug
vacuumdb: could not connect to database debug: FATAL: database is not
accepting comman
Hi List,
I am having a problem trying to do the following:
ssh postgres@192.168.198.93 'psql -Atc "select a.interface, a.source_ip,a.dest_ip
from kernel_gre a, ospfd_interface b where a.interface = b.interface and config ilike
'%cost 50%';" config.db'
bash turns it into this:
ssh postgres@192.
On 03/31/2011 02:06 PM, Arjen Nienhuis wrote:
On Thu, Mar 31, 2011 at 20:05, Arjen Nienhuis wrote:
On Thu, Mar 31, 2011 at 18:56, Steve Clark wrote:
Hi List,
I am having a problem trying to do the following:
ssh postgres@192.168.198.93 'psql -Atc "select a.interface,
a.source_ip
Hello,
I am confused by how postgres 8,4..13 is sorting my data.
\d test
Table "public.test"
Column | Type | Modifiers
+--+---
data | text |
select * from test order by data;
data
--
-
--
1
11
11F
1F
a
b
C
F
-F
Feneric
Generic
(14 rows)
Th
On 08/07/2014 11:36 AM, Kevin Grittner wrote:
Steve Clark wrote:
I am confused by how postgres 8,4..13 is sorting my data.
select * from test order by data;
data
--
-
--
1
11
11F
1F
a
b
C
F
-F
Feneric
Generic
(14 rows)
The
Hi list,
This may be really simple - I usually do it using a procedural language such as
php or a bash script.
Say I have a table that has 2 columns like
create table "foo" (
id integer not null,
name text
);
CREATE UNIQUE INDEX "foo_pkey" on "foo" using btree ( "id" "int4_ops" );
with 10
On 01/24/2013 12:36 PM, Jeff Janes wrote:
On Thu, Jan 24, 2013 at 8:53 AM, Chris Angelico wrote:
On Fri, Jan 25, 2013 at 3:47 AM, Steve Clark wrote:
Say I have a table that has 2 columns like
create table "foo" (
id integer not null,
name text
);
CREATE UNIQUE INDEX "fo
On 01/24/2013 01:06 PM, Chris Angelico wrote:
On Fri, Jan 25, 2013 at 4:45 AM, Steve Clark wrote:
Thanks All,
This is for a few very small tables, less 100 records each, that a user can
delete and insert records into based on the "id"
which is displayed in a php generated html s
Hello List,
I have a query that counts how many time an event occurs in our event_log these
are grouped by the serial number of the device that created the event. I would
like to show only the rows where the number of events exceeds some threshold.
simplified query:
select serial_no, count(*) as
On 02/22/2013 11:14 AM, Russell Keane wrote:
> select serial_no, count(*) as "restarts" from event_log where event_mesg ilike
'system sta%' and event_date > current_date - 7
> group by serial_no
> having count(*) > X
> order by restarts
I think having is the better option.
Thanks all, did
On 05/10/2013 12:46 PM, Merlin Moncure wrote:
On Fri, May 10, 2013 at 11:34 AM, Evan D. Hoffman
wrote:
I'd expect to use a RAID controller with either BBU or NVRAM cache to handle
that, and that the server itself would be on UPS for a production DB. That
said, a standby replica DB on conventio
Hello,
I seem to recall seeing somewhere that you can turn on an option that
will let you see what the \ command actually run, but googling and doing
a quick scan of the docs didn't turn it up. Could someone assist me on
this?
Thanks,
--
Stephen Clark
*NetWolves*
Director of Technology
Phone: 81
Hi List,
I am running postgresql 8.4.20 on CentOS 6. Things have been running fine for a
long time
then I rebooted. Postgres came up but when I tried to connect with psql on the
local machine
I got
psql: could not connect to server: No such file or directory
Is the server running locall
On 03/17/2017 09:49 AM, Adrian Klaver wrote:
> On 03/17/2017 06:42 AM, Steve Clark wrote:
>> Hi List,
>>
>> I am running postgresql 8.4.20 on CentOS 6. Things have been running fine
>> for a long time
>> then I rebooted. Postgres came up but when I tried to c
On 03/17/2017 10:14 AM, Adrian Klaver wrote:
> On 03/17/2017 06:58 AM, Steve Clark wrote:
>> On 03/17/2017 09:49 AM, Adrian Klaver wrote:
>>> On 03/17/2017 06:42 AM, Steve Clark wrote:
>>>> Hi List,
>>>>
>>>> I am running postgresql 8.4.20
Hello,
I am confused. I have a table that has an incrementing primary key id.
When I select max(id) from table is returns almost instantly but
when I select min(id) from table it takes longer than I want to wait.
Shouldn't postgresql be able to quickly find the minimum id value in the index?
p
Should add this is version 9.4.10 of postgresql
On 04/19/2017 11:24 AM, Steve Clark wrote:
> Hello,
>
> I am confused. I have a table that has an incrementing primary key id.
>
> When I select max(id) from table is returns almost instantly but
> when I select min(id) from tab
On 04/19/2017 11:57 AM, Jeff Janes wrote:
> On Wed, Apr 19, 2017 at 8:24 AM, Steve Clark <mailto:steve.cl...@netwolves.com>> wrote:
>
> Hello,
>
> I am confused. I have a table that has an incrementing primary key id.
>
> When I select max(id) from tab
Hello,
We have customers whose equipment we monitor. Some of the customers don't run a
24/7 operation
and turn their equipment off when the go home. We need to create a schedule for
them of when we
can ignore alerts from their equipment. We use postgresql in our monitoring
environment to mainta
On 06/20/2017 09:02 AM, Adrian Klaver wrote:
> On 06/20/2017 05:35 AM, Steve Clark wrote:
>> Hello,
>>
>> We have customers whose equipment we monitor. Some of the customers don't
>> run a 24/7 operation
>> and turn their equipment off when the go home. We
On 06/20/2017 10:38 AM, Adrian Klaver wrote:
> On 06/20/2017 07:00 AM, Steve Clark wrote:
>> On 06/20/2017 09:02 AM, Adrian Klaver wrote:
>>> On 06/20/2017 05:35 AM, Steve Clark wrote:
>>>> Hello,
>>>>
>>>> We have customers whose equipment we
Hi List,
I loaded 9.5 on CentOS 7 but by default every thing wants to use the default
9.2 version that comes with CentOS 7.
Is there a simple way to fix this so the 9.5 version of tools and libraries are
used.
Thanks,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
Hello List,
I am going to be setting up a warm standby postgresql 8.2.5 high
availability 2 server system. I was
wondering if anybody that has done this can share some scripts,
pertinent postgresql.conf entries,
etc so I don't have to reinvent the wheel. I have read the manual a
couple of time
Erik Jones wrote:
On Jan 31, 2008, at 10:04 AM, Steve Clark wrote:
Hello List,
I am going to be setting up a warm standby postgresql 8.2.5 high
availability 2 server system. I was
wondering if anybody that has done this can share some scripts,
pertinent postgresql.conf entries,
etc so I
Steve Clark wrote:
Hello List,
Don't know whether anyone here can help but... We have some code that
has compiled and ran just
fine from postgresql 7.3.x thru 8.2.6. It uses embedded sql. I just
yesterday upgraded our test system to
8.3.0 and this code will no longer compile. Below
Hello List,
Don't know whether anyone here can help but... We have some code that
has compiled and ran just
fine from postgresql 7.3.x thru 8.2.6. It uses embedded sql. I just
yesterday upgraded our test system to
8.3.0 and this code will no longer compile. Below is a standalone code
fragment
Michael Meskes wrote:
On Fri, Feb 29, 2008 at 11:27:25AM -0500, Steve Clark wrote:
Actually it appears to work in 8.2.5 but be broken in 8.2.6 and 8.3.0.
Are you really sure? It appears to me that there was no change between
8.2.5 and 8.2.6 that could affect ecpg's handling of arra
Michael Meskes wrote:
I just committed the attached small fix to CVS HEAD and the 8.3 branch.
This should fix your problem.
Michael
diff --exclude CVS -ru /home/postgres/pgsql-ecpg/preproc/type.c preproc/type.c
--- /hom
Hello List,
I can't seem to figure out what is this code that worked on 7.4.x.
I've added cast to everything but still
get:
postgres error log:
ERROR: operator does not exist: text = integer
HINT: No operator matches the given name and argument type(s). You
might need to add explicit type c
Charles Simard wrote:
|>
|> postgres error log:
|> ERROR: operator does not exist: text = integer
|> HINT: No operator matches the given name and argument type(s). You
|> might need to add explicit type casts.
|> STATEMENT: update T_MON_DEVICE_STATUS set device_ip = $1 :: inet
|> , s
Hello List
I have a program that worked fine in 7.4.19. I am in process of upgrading
to 8.3.1 and my program runs for a while and then hangs. I used gdb
to attach to the process and it shows the following backtrace which
shows it
going into the libpq library and getting stuck. Anybody have any
Tom Lane wrote:
Steve Clark <[EMAIL PROTECTED]> writes:
I have a program that worked fine in 7.4.19. I am in process of upgrading
to 8.3.1 and my program runs for a while and then hangs. I used gdb
to attach to the process and it shows the following backtrace which
shows it
going in
Hello List,
I am running 8.3.1 on FreeBSD 6.2 patch-7.
The ports for Freebsd turn on --enable-thread-safety during configure
of pg.
When running my app after some time I have been getting a core dump -
sig 11.
#0 0x28333b96 in memcpy () from /lib/libc.so.6
(gdb) bt
#0 0x28333b96 in memcp
Tom Lane wrote:
Steve Clark <[EMAIL PROTECTED]> writes:
The return from malloc should be checked to make sure it succeeds -
right???
Probably, but what do you expect the code to do if it doesn't succeed?
This function seems not to have any defined error-return
Tom Lane wrote:
Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
Note this is your in application, not the server. Only your program
died. Ofcourse the transaction got aborted, since the client (you)
disconnected. There is no way for this to write to the server log,
since it may be one anothe
Martijn van Oosterhout wrote:
On Sat, Mar 22, 2008 at 11:28:24AM -0400, Steve Clark wrote:
Retry - the malloc - maybe there is a memory leak when
--enable-thread-saftey is enabled,
send an out of memory message to the postgres log, abort the
transaction - I don't know I am
not a pos
Michael Meskes wrote:
On Sat, Mar 22, 2008 at 12:51:30PM -0400, Steve Clark wrote:
My program had no threads - as I pointed out if I change the default
Makefile in the FreeBSD ports
system to not enable thread safety my programs runs just fine for days
on end. It appears to me
without any
Steve Clark wrote:
Michael Meskes wrote:
On Sat, Mar 22, 2008 at 12:51:30PM -0400, Steve Clark wrote:
My program had no threads - as I pointed out if I change the default
Makefile in the FreeBSD ports
system to not enable thread safety my programs runs just fine for days
on end. It
Craig Ringer wrote:
Steve Clark wrote:
I guess the real question is why we are running out of memory when
this option is enabled.
Since my app doesn't use threads that points to a memory leak in the
ecpg library when enable thread
safety is turned on.
It might be worth building ecpg
Michael Meskes wrote:
On Sat, Mar 22, 2008 at 04:58:28PM -0400, Steve Clark wrote:
Not exactly sure what you are asking about - descriptors and auto
allocating.
So I guess you don't use either feature. :-)
The program processes about 80 packets a day, which can update
se
Hello List,
I have acquired the task of maintaining and existing application that uses
postgresql. I am only lightly versed
in sql and have the following problem I need to solve.
I have a table in which each row has a column - row_number. The row_numbers
need to be sequential.
Everything is fi
Scott Marlowe wrote:
On Wed, Jun 18, 2008 at 2:58 PM, Steve Clark <[EMAIL PROTECTED]> wrote:
Hello List,
I have acquired the task of maintaining and existing application that uses
postgresql. I am only lightly versed
in sql and have the following problem I need to solve.
I have a ta
Scott Marlowe wrote:
On Wed, Jun 18, 2008 at 3:50 PM, Steve Clark <[EMAIL PROTECTED]> wrote:
I realize this is certainly not the best design - but at this point in time
it can't be changed. The table
is rarely updated and never concurrently and is very small, typically less
than
only one row was deleted.
update meh
set id = id - 1
where id > 5;
At this point, if you've got a sequence that populates the id field,
you'll need to set its nextval.
Dave
On Thu, Jun 19, 2008 at 7:54 AM, Steve Clark <[EMAIL PROTECTED]
<mailto:[EMAIL P
David wrote:
Thanks for the tips, those make sense.
I was thinking through this some more after sending my mail, and came
to similar conclusions.
It would be nice though if this info was more available to people
doing research on the subject. Where did you pick up these ideas? At
least this thr
On 10/29/2009 04:42 PM, Scott Marlowe wrote:
On Thu, Oct 29, 2009 at 12:46 PM, Vick Khera wrote:
On my primary DB I'm observing random slowness which just doesn't make
sense to me. The I/O system can easily do 40MB/sec writes, but I'm
only seeing a sustained 5MB/sec, even as the application is
Hello,
Don't know if this is better asked on the CentOS ML or here, but...
CentOS 6 supplies 8.4.20 but I want to use hot standby - the issue is that the
PGDG
packages don't install into the "usual place" they are installed in version
specific directories,
including the data, binaries, librari
On 04/14/2014 09:02 AM, Moshe Jacobson wrote:
On Mon, Apr 14, 2014 at 8:24 AM, Steve Clark mailto:scl...@netwolves.com>> wrote:
CentOS 6 supplies 8.4.20 but I want to use hot standby - the issue is that
the PGDG
packages don't install into the "usual place"
Hello,
We have a small (2GB) 8.4.20 database. The prior maintainer ran a reindexdb
twice a day (originally started with 7.3.x). Can anybody see a reason why we
need to
continue to do this?
Thanks,
--
Stephen Clark
*NetWolves Managed Services, LLC.*
Director of Technology
Phone: 813-579-3200
F
On 05/08/2014 02:54 AM, Aqz wrote:
Hi.
I'm not sure if I should write here, or on a Centos mailing list...
I have fresh, vanilla Centos 6.5 with postgresql yum repository added.
I've successfully installed postgresql93 and postgresql93-libs packages, but
still :
$ ld -lpq
ld: cannot find -lpq
Hello List,
I am a not very experienced writing sql and I have a problem I can't readily
solve, so
I was hoping to get some help from this great list.
Here is my problem I have a table that has event data about the status of units
in the field. It has
many kinds of events one of which has down
On 10/13/2011 08:31 AM, Raymond O'Donnell wrote:
On 13/10/2011 12:17, Steve Clark wrote:
Hello List,
I am a not very experienced writing sql and I have a problem I can't
readily solve, so
I was hoping to get some help from this great list.
Here is my problem I have a table that has
On 12/16/2012 01:12 PM, Peter Bex wrote:
On Sun, Dec 16, 2012 at 06:48:35PM +0100, Andreas wrote:
With sed as startingpoint I figured it out.
Those 3 steps make the input files consumable for COPY
1. dos2unix
2. sed -i 's/[ \t]*$//'
3. sed -i 's/ / /g'
You can reduce this to one invocation by
On 05/07/2010 12:10 PM, AllieH wrote:
Yesterday I upgraded from Ubuntu 9.10 to 10.4. Unfortunately this has caused
me serious problems with everything related to postgreSQL. It seems as
though the new version of ubuntu is requiring me to use PostgreSQL 8.4
instead of 8.3 which I was previously u
On 05/07/2010 01:22 PM, Alan Hodgson wrote:
On Friday 07 May 2010, AllieH wrote:
Yesterday I upgraded from Ubuntu 9.10 to 10.4. Unfortunately this has
caused me serious problems with everything related to postgreSQL. It
seems as though the new version of ubuntu is requiring me to use
Post
On 07/13/2010 07:29 AM, Andras Fabian wrote:
Now, I have found an unorthodox way, to make a slow machine run COPY-to-STDOUT fast. I empty the cache memory
of the server, which makes "free" in "free -m" jump up to 14 GBytes (well, I just
noticed, that most of the memory on the server is in "cach
On 07/13/2010 10:35 AM, Andras Fabian wrote:
Hi Greg,
hmmm, thats true. Thos settings for example were much higher too (on the Ubuntu
server), than on our old machine.
New machine has:
- dirty_ratio = 20 (old has 10)
- dirty_background_ratio = 10 (old has 5)
But obviously setting vm.zone_recla
On 08/25/2010 12:30 PM, Joshua D. Drake wrote:
On Wed, 2010-08-25 at 12:20 -0400, Eric Comeau wrote:
Without even changing any line of data or code in sql !
Incredible, isn't it ?
Curious- what postgresql.conf settings did you change to improve it?
The most obvious would be to turn fsync
Hello List,
I want to change some columns in a database
that were originally created as char varying to
inet.
When I try I get an error. Is there anyway to work
around this?
See below for table definition.
Table "public.kernel_gre"
Column | Type | M
On 09/03/2010 09:38 AM, A. Kretschmer wrote:
In response to Steve Clark :
Hello List,
I want to change some columns in a database
that were originally created as char varying to
inet.
When I try I get an error. Is there anyway to work
around this?
See below for table definition
On 09/16/2010 05:26 PM, Aram Fingal wrote:
On Sep 16, 2010, at 4:37 PM, John R Pierce wrote:
On 09/16/10 10:44 AM, Aram Fingal wrote:
I have thought about that but later on, when we do the full sized
experiments, there will be too many rows for Excel to handle.
if you insist on this transpo
Hello List,
When an initdb is done where do the default postgresql.conf and pg_hba.conf
come from? Are they
copied from some template file?
Thanks,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailp
Hello List,
I have inherited an existing application. It has a table of events and some
events may reference an earlier
event. We have a script that saves the first N number of events for each
device, but we also want to save
any additional event that is referenced by one of the first N events.
Martijn van Oosterhout wrote:
On Wed, Aug 27, 2008 at 11:00:54AM -0400, Steve Clark wrote:
So I did an explain and I see it is doing a seq scan in the last sub plan -
there are about 375,000 rows
in myevent - why isn't it using the index instead of doing a seq scan?
create unique
Tom Lane wrote:
Steve Clark <[EMAIL PROTECTED]> writes:
explain insert into myevents select * from t_unit_event_log a where exists
(select b.event_log_no from myevents b
where a.event_status = 1 and a.event_ref_log_no IS NOT NULL
and a.event_ref_
Tom Lane wrote:
Steve Clark <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
Consider testing the conditions on A at the top level, instead of
redundantly checking them inside the sub-query on B.
Thanks for the response Tom, I am a SQL neophyte, so I'll try to
rework the query
Richard Broersma wrote:
On Tue, Sep 2, 2008 at 4:19 AM, Ivan Sergio Borgonovo
<[EMAIL PROTECTED]> wrote:
insert into d (pk, c1, c2, ...) select pk, c1, c2, c3 from s
where s.pk not in (select pk from d);
This insert statement might be faster:
INSERT INTO d (pk, c1, c2, ... )
SELECT pk, c1
Richard Broersma wrote:
On Tue, Sep 2, 2008 at 8:10 AM, Steve Clark <[EMAIL PROTECTED]> wrote:
Is there a way to do something similar with the following? I am an SQL noob
and the
following takes longer to run than is reasonable, on the order of hours.
insert into myevents select
Richard Broersma wrote:
On Tue, Sep 2, 2008 at 9:47 AM, Steve Clark <[EMAIL PROTECTED]> wrote:
srm2=# explain
srm2-# INSERT INTO Myevents
srm2-# SELECT *
ERROR: INSERT has more expressions than target columns
srm2=# explain
srm2-# INSERT INTO Myevents
srm2-# SELECT *
Tom Lane wrote:
"Richard Broersma" <[EMAIL PROTECTED]> writes:
There is one possible alteration that may or many not improve
performance. This would be to replace the EXISTS with a LEFT JOIN
WHERE IS NOT NULL;
That changes the behavior, doesn't it? Or is event_log_no a unique
key for Myeve
Scott Marlowe wrote:
On Tue, Sep 16, 2008 at 7:21 AM, Dragan Ciric <[EMAIL PROTECTED]> wrote:
Hi!
We need some help.
Sometimes we have broken connections with backend ( postgresql server ).
When this occurs, we have "idle in transaction" indication on server side. Can
you
answer us, how long
1 - 100 of 111 matches
Mail list logo
