Is it possible to select data from mulitple databases with a single sql
statement? Does postgresSQL allow the DB link to other database as Oracle?
Or any way to work around?
Howard
files without running a cluster. I am unsure if there is enough
data to actually start a cluster.
Thanks,
Howard.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 07/11/2016 13:12, Albe Laurenz wrote:
Howard News wrote:
I have a raid catastrophe which has effectively blitzed a cluster data
directory. I have several pg_dump backups but these will not restore
cleanly. I assume the disk has been failing for some time and the
backups are of the
On 07/11/2016 13:44, Vick Khera wrote:
On Mon, Nov 7, 2016 at 8:23 AM, Howard News wrote:
pg_restore: executing SEQUENCE SET example_seq
pg_restore: processing data for table example_table
pg_restore: [compress_io]
** crash **
What crashes? the pg_restore process or the backend server
On 08/11/2016 03:27, kaustubh kelkar wrote:
Hi ,
I am a PostgreSQL user who wants to create multiple instances of
PostgreSQL database server. I am using PostgreSQL 9.4 and above.
I tried to create more than 2 instances on Linux environment in which
I was successful. But, for windows environ
e CRC.
Is there a linux utility to do this or would it be simple to modify
pg_dump to do this?
Thanks
Howard.
www.selestial.com <http://www.selestial.com>
On 30/11/2016 12:27, Karsten Hilbert wrote:
You can try to suitably combine "pg_dump --format=plain" with
"tee" and "md5sum" such that the output stream is diverted to
both a file and a pipe-into-CRC-algorithm and eventually
compare the pipe's sum with the sum generated from the file.
But the
On 30/11/2016 13:05, basti wrote:
My question is. what does send so much traffic on an idle connection
within an hour?
Presumably they are only idle at the point you are viewing the
connections. In my typical usage, the connections are in a connection
pool and are mostly idle. Monitored ove
Regarding the filesystem solution, the dump is currently written to a HP
RAID 10 array with an NTFS partition. What filesystems / raid arrays have
this ability?
If you can't trust your RAID 10 (1 meaning mirrored) to
actually store what you told it to you've got problems beyond
somehow verifying
Use the same to_char expression in the where clause
2. Use a sub-select to use the alias in the outer where clause
3. Use the original column in the where clause and use the timestamp
comparisson functions.
Howard.
Hi,
I uninstalled the wrong version of postgres on Ubuntu using apt-get
remove postgresql-9.0, convinced that this was an old unused version.
You guess the rest...
The data files still appear to be there, all 485GB of them. Can these be
restored?
Thanks.
,
version 9.0
ii postgresql-9.1 9.1.20-1.pgdg1 object-relational SQL database,
version 9.1
ii postgresql-9.2 9.2.15-1.pgdg1 object-relational SQL database,
version 9.2
Does this mean it is removed?
On 24/03/2016 17:34, David Wilson wrote:
Hi Howard,
So long as you haven't touched anything
drinks of your choice.
Howard.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
I uninstalled the wrong version of postgres on Ubuntu using apt-get
remove postgresql-9.0, convinced that this was an old unused version.
You guess the rest...
The data files still appear to be there, all 485GB of them. Can these be
restored?
Thanks.
--
Sent via pgsql-general mailing
937 '-873':944
'-9972':945 '/partners/application.html':222
'/partners/program/program-agreement.pdf':271
'/partners/reseller.html':181,1073 '01756':50,1083 '07767':54,1087
'1':753,771 '12':366 '14
On 05/04/2016 14:44, Oleg Bartunov wrote:
On Tue, Apr 5, 2016 at 2:37 PM, Howard News <mailto:howardn...@selestial.com>> wrote:
Hi,
does anyone have any pointers for shrinking tsvectors
I have looked at the contents of some of these fields and they
contain man
On 05/04/2016 15:15, Artur Zakirov wrote:
On 05.04.2016 14:37, Howard News wrote:
Hi,
does anyone have any pointers for shrinking tsvectors
I have looked at the contents of some of these fields and they contain
many details that are not needed. For example...
"'+1':935
I'm seeing long-running transactions (pg_dump) canceled on the standby when
there are a lot of inserts happening on the master. This despite my having
set max_standby_streaming_delay to -1 on the standby.
Why might that happen?
This is pg 9.3.12. When it happens I see:
pg_dump: Dumping the con
ng replication in the mean
time.
On Sat, May 14, 2016 at 8:20 PM, Venkata Balaji N wrote:
>
> On Sat, May 14, 2016 at 12:27 PM, Jay Howard
> wrote:
>
>> I'm seeing long-running transactions (pg_dump) canceled on the standby
>> when there are a lot of inserts happeni
On Sun, May 15, 2016 at 6:15 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> Its customary to bottom-post (or respond inline) on these lists.
>
> On Sun, May 15, 2016 at 7:01 PM, Jay Howard
> wrote:
>
>> Do you have hot_standby_feedback set to "o
/Something else' where
email_directory_id=56
ERROR: attribute 3 has wrong type
SQL state: XX000
Detail: Table has type character varying, but query expects character
varying.
What has gone wrong?
Howard
www.selestial.com
---(end of broadcast)-
:
taskkill /f /pid 1234
This appeared to kill the session, but postgres still thinks the session
is live with the same process id.
Using the SysInternals process explorer - there doesn't appear to be a
process with the given ID.
How can I get postgres to drop this session?
Thanks
Howard
tivity and I cannot drop the database.
I eventually have to resort to restarting the postgres service, but this
is on a live system running several database so I do not want to have to
do this.
Any suggestions?
Ta
Howard
www.selestial.com
---(end of
(now
redundant for 4 days) and the mysterious connection is still there.
There has to be a better solution?
Howard.
Howard Cole wrote:
Hi,
I've written about this problem before and thanks to Bill Bartlett and
Richard Huxton for previous replies, but the problem keeps coming up...
I'
(can you do this on a
windows machine?) would disconnect all the databases which would be
major incident on the server.
Howard.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Thomas H. wrote:
On Tue, Dec 11, 2007 at 05:50:46PM -0500, Tom Lane wrote:
Alvaro Herrera <[EMAIL PROTECTED]> writes:
Howard Cole wrote:
I take it from the lack of response that nobody knows how to kill
a connection from the postgresql side on windows?
You can't, short of sendi
Which you can do, no? I thought pg_ctl's kill option was invented
specifically to make this less painful on Windows.
I shall look into the pg_ctl options to see if the kill option does
what taskill cannot (thanks for the heads up on that)
Using
$ pg_ctl kill TERM [pid]
worked great. Since v
sing pgAdmin
right?
P.S. The "pg_ctl kill TERM" worked fine.
Howard.
---(end of broadcast)---
TIP 6: explain analyze is your friend
Christmas / Eid / Holidays to you all and I'm looking
forward to 8.3 under the christmas tree.
Howard.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Hi all,
I don't understand the last result:
select 'Ho Ho Ho' ~* '^Ho'; returns true
select 'Ho Ho Ho' ~* ' Ho'; returns true
select 'Ho Ho Ho' ~* '[^ ]Ho'; returns false (Please note there is a
space between ^ and ])
From my limited experience of regex, the last one is searching for either
Richard Huxton wrote:
Howard Cole wrote:
Hi all,
I don't understand the last result:
select 'Ho Ho Ho' ~* '^Ho'; returns true
select 'Ho Ho Ho' ~* ' Ho'; returns true
select 'Ho Ho Ho' ~* '[^ ]Ho'; returns false (Please note th
Florian, Richard, Ivan.
Fantastic response thank you very much.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
Martijn van Oosterhout wrote:
On Thu, Dec 20, 2007 at 11:51:34AM +0100, A. Kretschmer wrote:
am Thu, dem 20.12.2007, um 10:36:08 + mailte Howard Cole folgendes:
Your expression works fine Richard, as does '(^| )ho', but can you tell
me why '[ ^]ho' doesn't
Howard Cole wrote:
Martijn van Oosterhout wrote:
On Thu, Dec 20, 2007 at 11:51:34AM +0100, A. Kretschmer wrote:
am Thu, dem 20.12.2007, um 10:36:08 + mailte Howard Cole
folgendes:
Your expression works fine Richard, as does '(^| )ho', but can you
tell me why '[ ^]h
!!!
;)
I am trying to match the beginning of a name, so to search for
'how' in 'Howard Cole' should match
'col' in 'Howard Cole' should match
'ole' in 'Howard Cole' should NOT match,
So using ~* '(^| )col' works for me! As wou
3 2011-02-01 11:003
Any ideas?
Thanks.
Howard
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
& Regards,
Vibhor Kumar
I have not come across that that function before. I'll take a closer look.
Many thanks to all for the quick responses.
Howard.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailp
On 04/04/2011 11:47 AM, salah jubeh wrote:
What will happen if
1. dropped table a
2. insert data on b and the other relations
3. restore table a and it's dependency (table b).
Simple advice would be to create a script on an offline system for
testing - when you are happy with the results - do
objects?
Thanks,
Howard Cole
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ent state - He knows! ;)
Assistance on this forum is s good. It puts most of the support I
pay for to shame. (for non postgres stuff)
Howard.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
gies for asking such a simple question but I am being a bit lazy as
I want to get on with releasing the MyDNS code.
Regards, Howard.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
Richard Huxton wrote:
Howard Wilkinson wrote:
I am working on some upgrades to the MyDNS open source product. I
have some expertise in MySQL but am not overly familiar with
PostgreSQL and need some guidance on how to query the schema for the
maximum size of data a column can hold.
Unless
Tino Wildenhain wrote:
Hi Howard,
Howard Wilkinson wrote:
I am working on some upgrades to the MyDNS open source product. I
have some expertise in MySQL but am not overly familiar with
PostgreSQL and need some guidance on how to query the schema for the
maximum size of data a column can hold
am I missing?
Thanks,
Howard
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I think I've solved this one - the compared the old to the new
postgresql.conf; the new version did not redirect the standard output.
Thanks.
Howard Cole wrote:
I've just installed Postgres 8.2.7 on a W2K3 machine, and created the
data directory post installation using initdb.
individually.
Anyway, this leads me to the question: Has anyone tried splitting
multiple database (10+) into clusters and what are the memory and
processor overheads in comparrison to more connections in a single cluster?
Thanks.
Howard.
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql
Can anyone give me a hint how to trace the cause of this error message
in the error log:
ERROR could not open relation 1663/20146/128342: Permission Denied
Running 8.2.7 on W2K3.
Thanks.
Howard Cole.
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
Looks like someone or something changed the permissions on the
postgresql folders or files.
Sincerely,
Joshua D. Drake
I've had a look at this file, and postgres has "Full Control".
Howard
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
Howard Cole wrote:
Looks like someone or something changed the permissions on the
postgresql folders or files.
Sincerely,
Joshua D. Drake
I've had a look at this file, and postgres has "Full Control".
Howard
Further, the system works fine normally. The permissions error
Adrian Klaver wrote:
On Friday 23 May 2008 6:02 am, Howard Cole wrote:
Howard Cole wrote:
Looks like someone or something changed the permissions on the
postgresql folders or files.
Sincerely,
Joshua D. Drake
I've had a look at this file, and postgres has "Fu
initive list of replacements that are required for
Postgres's version of Regular Expressions?
Howard.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
though I do not store my password in pgadmin.
This only seems to have become a problem since installing 8.4 and
associated version of pgadmin.
Is this the desired behaviour or is it a bug?
Howard Cole
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
Raymond O'Donnell wrote:
On 16/09/2009 10:55, Howard Cole wrote:
Hi All,
I have been having a few problems with my password file recently,
causing my scheduled pg_dump to fail. The problem is that the
pgpass.conf file keeps changing. Eventually I narrowed it down to using
pgadmin.
Richard Huxton wrote:
Raymond O'Donnell wrote:
On 18/09/2009 16:07, Howard Cole wrote:
Thanks for the update. Unfortunately this behaviour has the side effect
of deleting passwords that I have set up in the file manually for other
applications (namely the backup), which runs unde
Hi everyone,
Is data compressed when stored in a database table/field?
If not, is there an easy way (invisible to the database client) to
compress text and bytea data without actually using compressed disks?
Thanks.
Howard
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql
A. Kretschmer wrote:
http://www.postgresql.org/docs/current/static/storage-toast.html
Andreas
Thanks Andreas.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
docs/9.0/interactive/runtime-config-compatible.html#GUC-LO-COMPAT-PRIVILEGEScompatible.html#GUC-LO-COMPAT-PRIVILEGES
Howard
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
option to use the compatibility option and then, when you have
updated your code, you can turn off the compatibility mode and run your
script once.
Howard Cole
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
s
for how to graphically display sensor data over time.
Regards,
Greg Howard
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
build and then dumping
that database to restore in an 8.4.3 database, or just dump the existing
8.2.4 database and restore in 8.4.3?
Thanks.
Howard Cole
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
e was seamless.
Many thanks.
Howard Cole
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I am stumped, despite working on this for a week! I am trying to create a
64-bit postgresql 8.4 database server which can retrieve data from various
64-bit Oracle 10gR2 and 11gR2 databases.
- I have a freshly-installed 64-bit Centos 5.5, no firewall, no SELinux.
- I create an oracle user an
tter wrote:
> On Wed, Jun 30, 2010 at 10:10:02AM +1000, Howard Rogers wrote:
> > I am stumped, despite working on this for a week! I am trying to create a
> > 64-bit postgresql 8.4 database server which can retrieve data from
> various
> > 64-bit Oracle 10gR2 and 11g
On Thu, Jul 1, 2010 at 5:24 AM, David Fetter wrote:
> On Wed, Jun 30, 2010 at 10:10:02AM +1000, Howard Rogers wrote:
> > I am stumped, despite working on this for a week! I am trying to create a
> > 64-bit postgresql 8.4 database server which can retrieve data from
> various
&
On 06/03/2010 08:26 AM, Chris Browne wrote:
len.wal...@gmail.com (Len Walter) writes:
I need to populate a new column in a Postgres 8.3 table. The SQL would be something
like "update t set col_c = col_a +
col_b". Unfortunately, this table has 110 million rows, so running that query
runs out of
I have 10 million rows in a table, with full text index created on one
of the columns. I submit this query:
ims=# select count(*) from search_rm
ims-# where to_tsvector('english', textsearch)
ims-# @@ to_tsquery('english', 'woman & beach & ball');
count
---
646
(1 row)
Time: 107.570 ms
..
On Fri, Jul 16, 2010 at 10:23 AM, Tom Lane wrote:
> Howard Rogers writes:
>> I have 10 million rows in a table, with full text index created on one
>> of the columns. I submit this query:
>
>> ims=# select count(*) from search_rm
>> ims-# where to_tsvector
On Sat, Jul 17, 2010 at 3:14 AM, Tom Lane wrote:
> Howard Rogers writes:
>> OK, Tom: I did actually account for the number of rows difference
>> before I posted, though I accept I didn't show you that. So here goes:
>> ...
>> Both queries return zero rows. One ta
I asked recently about a performance problem I'd been having with some
full text queries, and got really useful help that pointed me to the
root issues. Currently, I'm trying to see if our document search
(running on Oracle Text) can be migrated to PostgreSQL, and the reason
I asked that earlier qu
On Mon, Jul 19, 2010 at 6:16 AM, Tom Lane wrote:
> Howard Rogers writes:
>> ims=# select count(*) from search_rm
>> where to_tsvector('english', textsearch) @@ to_tsquery('english','bat &
>> sb12n');
>> count
>> ---
>&g
Suppose 1=Red, 2=Yellow, 4=Green and 8=Orange.
Now suppose the following data structures and rows exist:
create table coloursample (recid integer, colour integer, descript varchar);
insert into coloursample values (1,2,'Yellow only');
insert into coloursample values (2,10,'Yellow and Orange');
in
On Wed, Jul 21, 2010 at 9:17 PM, Mathieu De Zutter wrote:
> On Wed, Jul 21, 2010 at 5:59 AM, Howard Rogers wrote:
>> It's also easy to find records which have either some yellow or some
>> orange (or both) in them:
>>
>> select * from coloursample where colour
On Thu, Jul 22, 2010 at 1:02 PM, Scott Marlowe wrote:
>>
>> Why on Earth would I want to store this sort of stuff in a bit string?!
>
> Because you are manipulating bits and not integers? I guess there are
> 10 kinds of people, those who like think in binary and those who
> don't.
>
>> I don't
On Fri, Jul 23, 2010 at 12:35 AM, Peter Hunsberger
wrote:
> On Wed, Jul 21, 2010 at 11:13 PM, Howard Rogers wrote:
>>
>> On Thu, Jul 22, 2010 at 1:02 PM, Scott Marlowe
>> wrote:
>>
>>
>> >>
>> >> Why on Earth would I want to store this
On Fri, Jul 23, 2010 at 8:37 AM, Scott Marlowe wrote:
> On Thu, Jul 22, 2010 at 3:09 PM, Howard Rogers wrote:
>> On Fri, Jul 23, 2010 at 12:35 AM, Peter Hunsberger
>> wrote:
>>> On Wed, Jul 21, 2010 at 11:13 PM, Howard Rogers wrote:
>>>>
>>>>
On Fri, Jul 23, 2010 at 3:02 PM, Scott Marlowe wrote:
>> If you mean, did I read the bit in the doco where it said nothing at
>> all in the 'these are great advantages' style I've just described, but
>> instead makes the fairly obvious point that a bit string takes 8 bits
>> to store a group of 8
On Fri, Jul 23, 2010 at 7:57 PM, Stephen Cook wrote:
> On 7/23/2010 5:33 AM, Howard Rogers wrote:
>>
>> ...so select * from table where 21205 | 4097 = 21205 would correctly
>> grab that record. So I'm assuming you mean the 'stored value' should
>> be on
> Hate to interrupt your flame war, and I apologize for not being precise in
> my meaning first try... You don't need any bitwise anything to compare two
> bitmasks-hiding-in-integers, just check for equality.
>
> Instead of "select * from coloursample where colour & 10 = 10;" just try
> "select *
On Fri, Jul 23, 2010 at 6:17 PM, Alban Hertroys
wrote:
>> I thought to do
>>
>> select * from coloursample where colour & 10 = 10;
>>
>> ...but that's not right, because it finds the third record is a match.
>
>
> What's not entirely clear to me is whether you only want to find colours that
> hav
Thanks to some very helpful input here in earlier threads, I was
finally able to pull together a working prototype Full Text Search
'engine' on PostgreSQL and compare it directly to the way the
production Oracle Text works. The good news is that PostgreSQL is
bloody fast! The slightly iffy news is
On Wed, Jul 28, 2010 at 8:38 PM, Daniel Verite wrote:
> zhong ming wu wrote:
>
>> I always thought there is a clause in their user agreement preventing
>> the users from publishing benchmarks like that. I must be mistaken.
>
> No you're correct. Currently, to download the current Oracle 11.
On Thu, Jul 29, 2010 at 10:33 PM, Dean Rasheed wrote:
> On 28 July 2010 02:58, Howard Rogers wrote:
>> For what it's worth, I wrote up the performance comparison here:
>> http://diznix.com/dizwell/archives/153
>>
>
> Thanks, very interesting results. I wonder, a
a query?
Thanks.
Howard Cole.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
down. The problem tend to be insert statements for binary
objects - which can be Megabytes long.
Is it possible to stop logging these excessive insert statements
somehow, or restricting the log of statements to select, delete etc and
ignore inserts.
Thanks.
Howard.
--
Sent via pgsql
Appologies if this has already been fixed, but I have come across a
problem with pg_dump when dumping a single non-public schema. (This is
on Windows Pg 8.2). It did not cause any major problems because I
obviously made a backup of the database before I tried a restore, and
managed to fix the b
Hello all,
Does postgres 8.3.* work on Windows w2k8 x64? I could not find any
reference to this on the website.
Thanks.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
assertive confirmations I shall get one
ordered! I'll assume you'll pay the bill to revert to W2k3 if it doesn't ;)
Howard.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ore all your
databases to the same point in time. So you cannot, as far as I am
aware, restore just one of the four databases.
Howard.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
follows:
max_connections=100
shared_buffers=128MB
work_mem=4MB
maintenance_work_mem=256MB
max_fsm_pages=204800
max_fsm_relations=1500
Any tips appreciated.
Howard.
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
Teodor Sigaev wrote:
The machine in question is a 1GB Ram, AMD 64 with Raid 1 Sata disks.
Non standard parts of my postgresql.conf are as follows:
max_connections=100
shared_buffers=128MB
work_mem=4MB
maintenance_work_mem=256MB
max_fsm_pages=204800
max_fsm_relations=1500
Any tips appreciated.
Scott Marlowe wrote:
Your entire disk io subsystem is a pair of hard drives. I'm assuming
software RAID.
Correct.
The time that this query takes is not the issue, rather it is the impact
that it has on the server - effectively killing it for the 40 seconds due to
the heavy disk access.
Scott Marlowe wrote:
The problem is most likely you're I/O bound. If one query is hitting
a table it can pull in data (sequentially) at 40 to 80 megabytes per
second. Since most of your queries are small, they don't run into
each other a lot, so to speak. As soon as your big reporting query
hit
Scott Marlowe wrote:
Best of luck on this.
Thanks Scott.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
dn't seem to speed up. Perhaps there
is something wrong with these databases? The explain analyse seems to
come back with identical plans on these. Any ideas? (p.s. I am running
autovacuum)
Howard Cole
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
Craig Ringer wrote:
Howard Cole wrote:
Unfortunately I am on a windows platform. Plus I am running windows
software raid so there is little tweaking allowed.
Don't write the possibility off too quickly. The driver may well accept
parameters for readahead settings etc, either thro
d with a SQL query but hopefully this shouldn't happen to
most people.
Hope this helps.
Howard Cole
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
times a day.
Howard Cole
www.selestial.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
I have not been able to use the tuning wizard in windows for postgresql
8.4 since it stops postgres starting so I have been looking to tweak the
postgresql.conf file directly. I am happy with the performance of
postgres in general but I feel that it is not utilising the memory on my
serve
Howard Cole wrote:
Hi,
I have not been able to use the tuning wizard in windows for
postgresql 8.4 since it stops postgres starting so I have been looking
to tweak the postgresql.conf file directly. I am happy with the
performance of postgres in general but I feel that it is not utilising
of 2 to 8 - checking the number
of connections at the time, they do not appear to be overloaded.
I am running 8.4.1 on Windows 2K3 with a C# application using Npgsql.
All connections are to the localhost and there is no firewall.
Help!
Howard Cole
www.selestial.com
--
Sent via pgsql-general
1 - 100 of 187 matches
Mail list logo
