#x27;s
great we have a hot standby, but if nobody knows how to use it in case the
master goes away, it's not so great.
THANK YOU for your assistance!
> On Feb 17, 2017, at 10:43 AM, Adrian Klaver wrote:
>
> On 02/16/2017 04:39 PM, Richard Brosnahan wrote:
>> Hi all
a different layout than this program
is expecting. The results below are untrustworthy.
Segmentation fault (core dumped)
Now I'm really unhappy. Same server architecture, same PostgreSQL versions. No
joy!
--
Richard Brosnahan
On Feb 17, 2017, at 10:43 AM, Adrian Klaver wrote:
On 02/
ave. This is easier than option 1, but I would need to find a
yum repo that has that version.
3 Make what I have work, somehow.
Any assistance would be greatly appreciated!
--
Richard Brosnahan
en if I manage
to get the mirror working with the current install, there's a real risk
something bad will happen. I can't trust this source built version.
Sigh
Thanks again for your help.
--
Richard Brosnahan
On Dec 15, 2016, at 01:00 PM, Tom Lane wrote:
Richard Brosna
need to do something more drastic, like blackmail a sys admin to coerce him to install PostgreSQL on the slave using RPM.
Thanks for the help!
--
Richard Brosnahan
On Dec 15, 2016, at 10:01 AM, Tom Lane wrote:
Richard Brosnahan writes:
I've got a PostgreSQL database server version 9.4.1 in
up? I wonder if the sys
admins take bribes...
THANKS in advance!!
--
Richard Brosnahan
On 07/15/16 12:13, Adrian Klaver wrote:
On 07/15/2016 09:06 AM, Tom Lane wrote:
Richard Kuhns writes:
I uninstalled 9.3 & installed the most recent 9.4. When I try to start
it, it tells me:
postgres[99770]: [1-1] FATAL: database files are incompatible with
server
postgres[99770]:
at the data that would be even better.
Any and all help would be greatly appreciated.
Thanks in advance.
--
Richard Kuhns
Wintek Corporation
427 N 6th Street
Lafayette, IN 47901-2211
Main: 765-742-8428
Direct: 765-269-8541
--
Sent via pgsql-general mailing list (pgsql-general@postgresql
ew link for it:
> https://commitfest-old.postgresql.org/action/patch_view?id=1293
Thanks!
Richard.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
rching in the wrong places and/or for the
wrong terms, it's happened before so apologies if I'm missing the obvious.
Thanks!
Richard.
--
Those who do not understand SQL are condemned to reinvent it, poorly
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
On 6 Oct 2014, at 17:54, Igor Neyman wrote:
>
>> -Original Message-
>> From: pgsql-general-ow...@postgresql.org
>> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Richard
>> Frith-Macdonald
>> Sent: Monday, October 06, 2014 4:02 AM
&g
I'm wondering if anyone can help with advice on how to manage large lists/sets
of items in a postgresql database.
I have a database which uses multiple lists of items roughly like this:
CREATE TABLE List (
ID SERIAL,
Name VARCHAR
);
and a table containing individual entries in the lis
ll roll-back the changes.
--
Regards,
Richard Broersma Jr.
I am doing wrong?
In your UPDATE statement, I'd suggest explicitly putting the "T" table alias
before each column you're setting. That will make the assignment more explicit
and hopefully get around the error.
>
> Also, is there an easier way to do that?
>
> Thanks for the help.
Best,
Richard Dunks
?
This shouldn't really be possible without disabling autovaccuum or
configuring it strangely.
http://www.postgresql.org/docs/current/static/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
If you use the literals directly the context lets PostgreSQL figure it out.
SELECT levenshtein('1','2');
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Okay, how about
PostgreSQL - The DataBase with 10,000 programmers on your side.
PostgreSQL - You wish the rest of your stuff was this good.
PostgreSQL - apply many quotes to mug
On Thu, Sep 5, 2013 at 12:37 PM, Atri Sharma wrote:
> On Fri, Sep 6, 2013 at 12:35 AM, Marc Balmer wrote:
>
How about an elephant flying around Earth.
Caption: PostgreSQL - Used all around the World
On Wed, Sep 4, 2013 at 1:58 PM, Gavin Flower
wrote:
> On 05/09/13 08:40, patrick keshishian wrote:
>
> On 9/4/13, Andreas 'ads' Scherbaum
> wrote:
>
> On 09/04/2013 10:17 PM, Stefan Kaltenbrunner wro
.
I'd like there to be a header in my files. I have to use CSVs instead.
Late to the discussion, but it does work to set format=csv and delimiter
= E'\t' to get tab-separated. Be nice not to have to though.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mail
RT INTO t1 VALUES('az');
INSERT INTO t1 VALUES('by');
INSERT INTO t1 VALUES('cx');
SELECT '1', substr(m,2) AS m FROM t1 ORDER BY m;
SELECT '2', substr(m,2) AS m FROM t1 ORDER BY m COLLATE "POSIX";
If that is n
On Wed, Aug 14, 2013 at 2:28 PM, Scott Marlowe wrote:
> On Wed, Aug 14, 2013 at 12:01 PM, Richard Hipp wrote:
>
> substr(m,2) as m
>
> is bad form. Always use a new and unique alias, like m1. How does this
> work:
>
> SELECT '2', substr(m,2) AS m1
> FROM
n names in the source table take precedence over
result column name, or should it be the other way around?
Any insights are appreciated. Please advise if a different mailing list
would be more appropriate for this question.
--
D. Richard Hipp
d...@sqlite.org
nf/elephant-roads-a-tour-of-postgres-forks
--
Regards,
Richard Broersma Jr.
> --
> Álvaro Herrerahttp://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Regards,
Richard Broersma Jr.
renamed columns,
> etc.
>
> Thanks in advance for your precious help,
>
> --
> Lionel
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Regards,
Richard Broersma Jr.
. If I'm correct that this feature is
> not currently present, would adding it be a reasonable feature request? How
> would I go about making a feature request? (My apologies if there is a
> how-to on feature requests somewhere; my searching didn't turn it up.)
>
> Thank you.
>
--
Regards,
Richard Broersma Jr.
Yours,
> Laurenz Albe
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Regards,
Richard Broersma Jr.
se a connection pooler.
You'll also need to reduce work_mem to 1MB or so.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
et
Postgres do the rest for you. Obviously if you need to have a separate table B
ID, you can alter as necessary.
Good luck,
Richard Dunks
On Jun 10, 2013, at 7:29 PM, Aleksandr Furmanov
wrote:
> Hello,
> I want to insert new values into target table 'a' from source table &
protect against? Make
a list of possible failures and what they mean to the business/project
and then decide how much time/money to spend protecting against each one.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
cases where you want (a), but lots where you want (b) and
monitor the replication lag.
[1] For various values of "safely" of course
[2] In the same mode - adding async slaves doesn't count
[3] Assuming a reasonable write load of course. Read-only databases
won't care.
--
partition. Thus I end up with 120 records when I am expecting
just 60.
Any ideas on how I can fix this issue?
Regards,
Richard
From: Richard Onorato
To: Raghavendra
Cc: "pgsql-general@postgresql.org"
Sent: Wednesday, May 22, 2013 7:27 PM
S
Raghavendra,
I am doing my inserts via Java JPA statements embedded in my Data Access Layer.
I can share them if you would like to see them.
Regards,
Richard
From: Raghavendra
To: Richard Onorato
Cc: "pgsql-general@postgresql.org"
Sent:
-increment supported on table partitioning?
Regards,
Richard
From: Raghavendra
To: Richard Onorato
Cc: "pgsql-general@postgresql.org"
Sent: Tuesday, May 21, 2013 1:06 PM
Subject: Re: [GENERAL] Table Partitioning
On Tue, May 21, 2013 at 11:03 P
Interesting. I wonder what I am doing wrong. I will try and setup the
database again and see if I can get it to work.
thank you for testing it out for me.
Richard
On May 21, 2013, at 1:06 PM, Raghavendra
wrote:
> On Tue, May 21, 2013 at 11:03 PM, Richard Onorato
> wrote:
> I a
OW EXECUTE PROCEDURE my_mapping_table_insert_trigger();
SET constraint_exclusion = ON;
Regards,
Richard
?
An update affects all rows that match the given condition so you'd get
both rows updated in this case. There's no LIMIT or ORDER BY available
in UPDATE.
Richard
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
lidas:
barman : Depende: python (< 2.7) pero 2.7.3-4 va a ser instalado
Depende: python-argcomplete pero no va a instalarse
Since when 2.7.3 isn't larger then 2.7.
Is that not complaining that it *wants* a version of python < 2.7 and
you have larger?
--
Richard Huxto
vel/static/event-triggers.html
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
nges CALLING PROCEDURE ...;
A different "feel", but no difference in behaviour.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
cipient names and the system would populate the country fields
for you by looking up in persons, throwing an error if appropriate.
Richard
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
it. It was the psycopg adapter. My bad!!
Thanks Adrian / Tom.
Rich
On 8 Apr 2013, at 14:58, Adrian Klaver wrote:
> On 04/08/2013 06:49 AM, Richard Harley wrote:
>> It's
>>
>&
n Klaver wrote:
> On 04/08/2013 06:45 AM, Richard Harley wrote:
>> I am running the query straight through PSQL so there are no other programs
>> or adapters.
>>
>> The field definition is just 'timestamp'.
>
> From psql what do you get if yo
I am running the query straight through PSQL so there are no other programs or
adapters.
The field definition is just 'timestamp'.
I did try that as well - no luck :)
Rich
On 8 Apr 2013, at 14:36, Adrian Klaver wrote:
> On 04/08/2013 06:27 AM, Richard Harley w
Sure
Timestamp
2013/04/08 12:42:40 GMT+1
2013/04/08 12:42:33 GMT+1
2013/04/07 20:25:11 GMT+1
2013/04/07 20:19:52 GMT+1
2013/04/07 20:19:52 GMT+1
Some are GMT, some are GMT+1 depending on when they were entered.
On 8 Apr 2013, at 14:25, Adrian Klaver wrote:
> On 04/08/2013 06:22 AM, Rich
This doesn't seem to work - take a normal GMT date for example: 2012/12/14
12:02:45 GMT
select timestamp from attendance where timestamp = '2012/12/14 12:02:45'
..returns nothing
On 8 Apr 2013, at 14:17, Adrian Klaver wrote:
> On 04/08/2013 06:03 AM, Richard Harley w
Hello all
Pretty sure this should be simple - how can I select a timestamp from a
database?
The timestamp is stored in the db like this:
2013/04/08 13:54:41 GMT+1
How can I select based on that timestamp?
At the simplest level "select timestamp from attendance where timestamp =
'2013/04/08 1
On 26/03/13 13:24, Clemens Eisserer wrote:
Hi Richard,
Will triggers (after
update specifically) cause the execution of SQL-commands to pause
until the trigger-function has returned (at statement execution time
or commit)?
The trigger will block. If it didn't then it couldn't
be reproduced,
adapted or communicated without the prior written consent of the
copyright owner.
Oh no, too late!
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
umn, which is not pretty but should be
fairly simple.
Why not use one of the established trigger-based replication solutions?
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.or
ck and also not updating any
indexed fields (and you were, I think).
A GIN index is very expensive to update compared to btree too.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgres
thout the
fillfactor and with/without the GIN index while you do the updates. It's
possible your SSD is just behaving oddly under stress.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscrip
en year old PCs with
very little RAM and disk space. At least deliver additional conf files
for small, medium, large, huge setups.
--
Richard Huxton
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
updating those rows whose id has changed -
that seemed to be the suggestion in your first message. If not, simply
adding "AND make_id <> md.make_id" should help. Also (and you may well
have considered this) - for a normalised setup you'd just have the
model-id in "import
write. If it's much faster then something else is
happening.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
in "escape" rather than "hex" format.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
141 | B-0307
74 | B-0423
(10 rows)
--
Regards,
Richard Broersma Jr.
ump to dump the
database regularly too. I'd expect to have to do a little work to move
the data into an up-to-date version of PostgreSQL and it's always better
to know what issues you'll have before doing it for real.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-gener
i think pl/java may expect the method signatures to match up precisely. not
entirely sure, as there are no
examples published as to how pl/java expects out parameters to work.
richard
From: Thomas Hill [thomas.k.h...@t-online.de]
Sent: Monday, November
Edson Richter [edsonrich...@hotmail.com] writes:
>Em 19/11/2012 15:26, Welty, Richard escreveu:
>> PL/Java requires that the methods being directly called from PostgreSQL are
>> static.
>> while i don't disagree with the advice, PL/Java is limited in this respect.
>
a is limited in this respect.
richard
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
production so long as you have good processes in
place and can dedicate some developer time to learning & supporting it. but
it's definitely not plug and play right now.
richard
From: pgsql-general-ow...@postgresql.org [pgsql-general-ow...@postgresql
On 16/11/12 19:35, Shaun Thomas wrote:
Hey guys,
So, we have a pretty beefy system that runs dual X5675's with 72GB of
RAM. After our recent upgrade to 9.1, things have been... odd. I
managed to track it down to one setting:
shared_buffers = 8GB
It does the same thing at 6GB. 4GB is safe
7;2170501'
How may I get more information about this deadlock like which queries
created it.
The error message shows which queries - your two UPDATEs. I'm guessing
either t1 or c1 are views and so refer to the same row with id "2710501".
--
Richard Huxton
--
Sent
nsaction information will have been lost.
But before you do anything drastic, do steps #1 and #2.
--
Richard Huxton
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Other than that, it seems to work fine.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
tform/SUNW,Sun-Fire-V890/lib/sparcv9/libc_psr.so.1
/platform/SUNW,Sun-Fire-V890/lib/sparcv9/libmd_psr.so.1
Thank you for helping to point out where the actual problem lies. The ldd
command is showing that there is a library issue with trying to use the 9.0.8
version.
Rebuilt the PostgreSQL server software because we were patching up from 9.0.4
to 9.0.8. Deployed software and received the following error when trying to
restart server.
fgets failure: Error 0
The program postgres is needed by pg_ctl but was not found in the same
directory as pg_ctl
9.0.4 wor
l(n_user);
EXECUTE cmd;
or just
EXECUTE 'NOTIFY demoApp, ' || quote_literal(n_user);
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
port numbers are restricted to 2 octets (16 bits). they are TCP/IP entities and
are restricted in size by the RFCs (internet standards.)
richard
-Original Message-
From: pgsql-general-ow...@postgresql.org on behalf of Alberto Zanon
Sent: Wed 5/23/2012 10:19 AM
To: Merlin Moncure
Cc
Okay, should the 9.2 beta announcement and press releases be amended
to show this link rather than the ones posted?
On Wed, May 16, 2012 at 10:40 AM, Guillaume Lelarge
wrote:
> On Wed, 2012-05-16 at 10:28 -0700, Richard Broersma wrote:
>> I've seen the following statement made
e any results:
http://www.postgresql.org/download/
or
http://www.postgresql.org/download/windows/
or
http://www.enterprisedb.com/products-services-training/pgdownload#windows
Are we waiting for a refresh on the download page?
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mailing list (pgsql-genera
ot;strict" then any null parameters
automatically result in a null result.
And indeed, this:
SELECT * FROM pg_proc WHERE proname LIKE 'regexp_r%';
shows pro_isstrict is set to true, as it is for most other function.s
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-gene
On 09/05/12 00:00, Tomas Vondra wrote:
On 8.5.2012 19:27, Richard Harley wrote:
I currently do nightly database dumps on a ton of small dbs that are
increasing around 2-3mb per day. Suddenly, in a recent backup file, one
db in particular jumped from 55mb to 122mb overnight.
Well, I wouldn&#
I currently do nightly database dumps on a ton of small dbs that are
increasing around 2-3mb per day. Suddenly, in a recent backup file, one
db in particular jumped from 55mb to 122mb overnight.
I did some investigation -
One table increased from 8mb to 31mb during a 24hr period. The table is
ook at Btree_gist index:
http://www.postgresql.org/docs/9.1/static/btree-gist.html
I think this is the part that your missing.
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ic.pref_scores
DROP CONSTRAINT pref_scores_gid_fkey,
ADD CONSTRAINT pref_scores_gid_fkey
FOREIGN KEY (gid)
REFERENCES pref_games(gid)
ON DELETE CASCADE;
--
Regards,
Richard Broersma Jr.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
in the RHEL and related linux systems (Fedora, CentOS, Amazon EC2 Linux), use
this
command:
chkconfig postgresql on
to set up postgresql to start at boot. it needs to be executed as root.
richard
-Original Message-
From: pgsql-general-ow...@postgresql.org on behalf of leaf_yxj
ar behind the replica could never catch up). You can
control how long before it switches:
http://www.postgresql.org/docs/9.1/static/hot-standby.html#HOT-STANDBY-CONFLICT
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make ch
some of you may have seen this in the NYT two weeks ago:
http://bits.blogs.nytimes.com/2012/04/05/pentagon-pushes-crowdsourced-manufacturing/
just FYI, the database being used by the MIT/GE team is PostgreSQL 9.1.3
cheers,
richard
can anyone recommend an open source tool for diffing schemas?
(it should go without saying that i'm looking for ddl to update production and
QA DBs from development DBs, but i'll say it, just in case.)
thanks,
richard
h just yet.
richard
-Original Message-
From: Michael Nolan [mailto:htf...@gmail.com]
Sent: Mon 4/2/2012 7:19 PM
To: Welty, Richard
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] 9.1.3: launching streaming replication
On Mon, Apr 2, 2012 at 4:21 PM, Welty, Richard wrote:
I g
several iterations and fixed some problems, and wonder if there's
obsolete data that is messing things up?
thanks,
richard
On 30/03/12 08:46, Pavel Stehule wrote:
2012/3/30 Richard Huxton:
On 29/03/12 23:28, Pavel Stehule wrote:
select anum from t1 where anum = 4
union all select 100 limit 1;
I'm not sure the ordering here is guaranteed by the standard though, is it?
You could end up with the 4 being disc
On 29/03/12 23:28, Pavel Stehule wrote:
select anum from t1 where anum = 4
union all select 100 limit 1;
I'm not sure the ordering here is guaranteed by the standard though, is
it? You could end up with the 4 being discarded.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-ge
does anyone have any tips on this? Linux Software Raid doesn't seem to be doing
a very good job here, but i may well have missed something.
i did a fairly naive setup using linux software raid on an amazon linux
instance,
10 volumes (8G each), (WAL on a separate EBS volume) with the following se
above.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
hybrid solutions so I
>could potentially lease a dedicated server and continue to host my web
>frontend servers on the cloud.
that's good to know, although for the project i'm working on, EC2 is
what we have to work with, good parts and bad parts and all.
richard
ntify headings etc.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Thanks for a quick reply. The server has 6 cores, 6GB ram and top gets
to 2.3-2.5 load average when running the dumpall. So I assume we are
nowhere near this causing performance issues for users?
Thanks
Rich
On 15/03/12 12:21, Bèrto ëd Sèra wrote:
Hi Richard,
it's no easy answer. If
Hello all
Very simple question - does pg_dump/dumpall hit the server in terms of
database performance? We currently do nightly backups and I want to move
to hourly backups but not at the expense of hogging all the resources
for 5 mins.
Pg_dumpall is currently producing a 1GB file - that's t
s along shortly, try reposting to
the performance list. There are people there who are used to machines of
this size.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
just installed a script, which prints me out the top and ps axf information
for facing out the problem. I will post a snippet of the top here:
Combine that with this:
SELECT * FROM pg_stat_activity;
That will let you line up pids from top with active queries.
--
Richard Huxton
Archonet
On 24/02/12 13:37, Andrew Gould wrote:
On Fri, Feb 24, 2012 at 7:32 AM, Richard Huxton wrote:
Temp tables get their own schema, and each session (connection) gets
its own temp schema. So - don't qualify them by schema.
Is that to avoid naming conflicts between simultaneous users?
Y
OP TABLE table1;
DROP TABLE
=> SELECT * FROM table1;
id
1
2
3
(3 rows)
Try "SELECT * FROM pg_namespace" to see the various temp schemas being
created.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
annot create temporary relation in non-temporary schema
Temp tables get their own schema, and each session (connection) gets
its own temp schema. So - don't qualify them by schema.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
r some such).
http://archives.postgresql.org/pgsql-admin/2011-09/msg00088.php
http://archives.postgresql.org/pgsql-admin/2011-09/msg00101.php
Do you have version 9.0 installed too?
--
Richard Huxton
Archonet Ltd
8.4 - you will get better performance, new features and it will be
supported for longer.
--
Richard Huxton
Archonet Ltd
Ralph,
It may help to break this into a couple of parts
Make a folder called c:\cronjobs
in c:\cronjobs create a bat file that contains the commands you want
executed.
Maybe something like
set logfile=shp2pgsql.log
echo Running shp2pgsql > %logfile%
date /t >> %logfile%
time /t >> %logfile%
shp2
- the cast to int is because count() returns bigint.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
1 - 100 of 3138 matches
Mail list logo
