Hi
I'm trying to build a Windows Form application that needs to alter the
definition of a View, depending on user input/selection. Essentially,
the user is selecting a property of known coordinates ('x','y') and
setting a 'buffer' distance . I then want to retrieve the records which
represent
On 10 May 2010, at 24:01, Christoph Zwerschke wrote:
We want to find all entries in b where txt begins with an
existing txt entry in a:
select * from b join a on b.txt like a.txt||'%'
On the first glance you would expect that this is performant
since it can use the index, but sadly it
On 10 May 2010, at 6:02, Boyd, Craig wrote:
I have been using PostgreSQL for a short while, but I have not had to use the
pg_catalog tables before and the columns are a little cryptic to me. I think
it ties to pg_class, but I am not sure how to relate them. Also, I have not
had a chance
On 10 May 2010, at 2:09, Jonathan Vanasco wrote:
i was given a unique index on
(country_id, state_id, city_id, postal_code_id)
in the two records below, only country_id and state_id are assigned ( aside
from the serial )
geographic_location_id | coordinates_latitude |
I've encountered the following problem:
ivoras=# create table htest2(id integer, t hstore);
CREATE TABLE
ivoras=# create table htest3(id integer, t2 hstore);
CREATE TABLE
ivoras=# select id, t from htest2 union select id,t2 as t from htest3;
ERROR: could not identify an ordering operator for
Bruce Momjian wrote:
Bruce Momjian wrote:
John Gage wrote:
Is the documentation available anywhere as a single page text file?
This would be enormously helpful for searching using regular
expressions in Vim, for example, or excerpting pieces for future
reference.
Uh, no, and no one has
How to get around this? I really don't care how hstores get sorted and
more, would like to avoid sorting them at all as they could get big.
union all
seems to work. Would that serve the purpose?
Regards,
Jayadevan
DISCLAIMER:
The information in this e-mail and any attachment is
When we do a union, the database has to get rid of duplicates and get
distinct values. To achieve this, probably it does a sort. Just
guesswork
Regards,
Jayadevan
DISCLAIMER:
The information in this e-mail and any attachment is intended only for
the person to whom it is addressed and
On 05/10/10 14:10, Jayadevan M wrote:
When we do a union, the database has to get rid of duplicates and get
distinct values. To achieve this, probably it does a sort. Just
guesswork
You are right, it looks like I have inverted the logic of UNION and
UNION ALL - I actually needed UNION ALL
On 5/10/2010 4:43 AM, OisinJK wrote:
Hi
I’m trying to build a Windows Form application that needs to alter the
definition of a View, depending on user input/selection. Essentially,
the user is selecting a property of known coordinates (‘x’,’y’) and
setting a ‘buffer’ distance . I then want to
On May 10, 2010, at 6:29 AM, Alban Hertroys wrote:
As the docs state and as others already mentioned, Null values are
not considered equal.
Ah. I interpreted that wrong. I thought it applied to indexes
differently. I'll have to experiment now...
--
Sent via pgsql-general mailing
On Sat, May 8, 2010 at 12:12 AM, Mike Christensen m...@kitchenpc.com wrote:
What's the best way to do this? Looks like something like pgPool
might be what I want, but I haven't looked into it deeply yet.
I don't think your requirement and postgres are consistent with each
other.Unless your
Excerpts from John Gage's message of sáb may 08 05:06:35 -0400 2010:
Is the documentation available anywhere as a single page text file?
This would be enormously helpful for searching using regular
expressions in Vim, for example, or excerpting pieces for future
reference.
There's a
Excerpts from Alvaro Herrera's message of lun may 10 12:01:22 -0400 2010:
There's a texinfo output that could perhaps be useful. Try
make postgres.info in the doc/src/sgml directory; while it's tagged
experimental and outputs a boatload of warnings, it does work for me and the
text it
On Fri, May 7, 2010 at 10:12 PM, Mike Christensen m...@kitchenpc.com wrote:
I'm considering using a cloud hosting solution for my website. It
will probably be either Amazon, Rackspace or Hosting.com. I'm still
comparing. Either way, my site will consist of multiple virtual
server instances
I would like to replicate the following Unix pipe within a Perl script,
perhaps using DBD::Pg:
% pg_dump -Z9 -Fc -U DB_USER FROM_DB | pg_restore -v -d TO_DB -p
SSH_TUNNEL_PORT -h localhost -U DB_USER
Of course, I can try to use Perl's system, and the like, to run this pipe
verbatim, but I this
Hi,
I have a question about a feature in PostgreSQL 9.0.
I am looking for support for windowing functions when using: RANGE
BETWEEN value PRECEDING/FOLLOWING AND value
PRECEDING/FOLLOWING
The latest documentation:
I am using the Mac and, although the Mac does not ship with this, the
Zotero add-on to Firefox includes it:
/Users/johngage/Library/Application Support/Firefox/Profiles/
m35vu1ez.default/zotero/pdftotext-MacIntel
Will try it out. Thanks very much,
John
On May 10, 2010, at 1:58 PM,
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
I would like to replicate the following Unix pipe within a Perl script,
perhaps using DBD::Pg:
% pg_dump -Z9 -Fc -U DB_USER FROM_DB | pg_restore -v -d TO_DB -p
SSH_TUNNEL_PORT -h localhost -U DB_USER
Of course, I can try to use Perl's
Excerpts from Daniel Scott's message of lun may 10 13:20:06 -0400 2010:
Says The value PRECEDING and value FOLLOWING cases are currently only
allowed in ROWS mode.
However, I have found this post:
On Sun, May 9, 2010 at 8:33 AM, Ovid curtis_ovid_...@yahoo.com wrote:
My apologies. This isn't PG-specific, but since this is running on PostgreSQL
8.4, maybe there are specific features which might help.
I have a tree structure in a table and it uses materialized paths to allow me
to find
On Sun, May 9, 2010 at 4:47 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Ovid curtis_ovid_...@yahoo.com writes:
My apologies. This isn't PG-specific, but since this is running on
PostgreSQL 8.4, maybe there are specific features which might help.
I have a tree structure in a table and it uses
On Mon, 2010-05-10 at 17:33 +, Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
I would like to replicate the following Unix pipe within a Perl script,
perhaps using DBD::Pg:
% pg_dump -Z9 -Fc -U DB_USER FROM_DB | pg_restore -v -d TO_DB -p
Hi,
On Mon, May 10, 2010 at 13:35, Alvaro Herrera alvhe...@alvh.no-ip.org wrote:
It was ripped out of the patch before commit because the implementation was
not
acceptable.
That's strange - the CommitFest says that it was committed and I can't
find any mention of it being removed. Is there
Am 10.05.2010 11:50 schrieb Alban Hertroys:
On 10 May 2010, at 24:01, Christoph Zwerschke wrote:
select * from b join a on b.txt like a.txt||'%'
I feel there should be a performat way to query these entries,
but I can't come up with anything. Can anybody help me?
Have you tried using
On Mon, May 10, 2010 at 1:33 PM, Greg Sabino Mullane g...@turnstep.comwrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
I would like to replicate the following Unix pipe within a Perl script,
perhaps using DBD::Pg:
% pg_dump -Z9 -Fc -U DB_USER FROM_DB | pg_restore -v -d
On Mon, May 10, 2010 at 2:59 PM, Joshua D. Drake j...@commandprompt.comwrote:
On Mon, 2010-05-10 at 17:33 +, Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
I would like to replicate the following Unix pipe within a Perl script,
perhaps using
Daniel Scott djsc...@mit.edu writes:
On Mon, May 10, 2010 at 13:35, Alvaro Herrera alvhe...@alvh.no-ip.org wrote:
It was ripped out of the patch before commit because the implementation was
not
acceptable.
That's strange - the CommitFest says that it was committed and I can't
find any
Kynn Jones kyn...@gmail.com writes:
But I have not found a way for my script to provide a password when it
runs commands like dropdb, createdb, and pg_restore with the -h REMOTE
HOST flag. So I end up resorting to SSH-tunneling. This is what I'm
trying to avoid.
You don't really want to
Alban Hertroys dal...@solfertje.student.utwente.nl wrote:
[...]
None of these solutions are pretty. It should be quite a common problem
though, how do people normally solve this?
Partial indexes? Doesn't look pretty either though:
| tim=# \d DE_Postcodes
| Tabelle »public.de_postcodes«
|
Kynn Jones kyn...@gmail.com writes:
Actually, that was a mistake on my part. That should have been -Ft rather
than -Z9 -Fc, since I *don't* want compression (most of the data being
transmitted consists of highly incompressible blobs anyway). Regarding SSH,
my understanding is that to get
as it keeps coming up on the list off and on, I decided to write a wiki article,
comments suggestions
http://wiki.postgresql.org/wiki/BinaryFilesInDB
I also read over the 9.0 beta release notes, bytea type now allows hex values??
The solution is very simple and can be done in the cPanel configuration,
just disabled Shell Fork Bomb Protection in the security center. That's
all. The ulimit restrictions are removed!
Huh, that's interesting. With a name like that, I'd have thought it
would set limits on number of
On 5/10/2010 2:46 PM, Kynn Jones wrote:
On Mon, May 10, 2010 at 1:33 PM, Greg Sabino Mullane g...@turnstep.com
mailto:g...@turnstep.com wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
I would like to replicate the following Unix pipe within a Perl
script,
On 10 May 2010, at 20:06, Greg Stark wrote:
On Sun, May 9, 2010 at 4:47 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Ovid curtis_ovid_...@yahoo.com writes:
My apologies. This isn't PG-specific, but since this is running on
PostgreSQL 8.4, maybe there are specific features which might help.
I have
On 10 May 2010, at 21:24, Christoph Zwerschke wrote:
Am 10.05.2010 11:50 schrieb Alban Hertroys:
On 10 May 2010, at 24:01, Christoph Zwerschke wrote:
select * from b join a on b.txt like a.txt||'%'
I feel there should be a performat way to query these entries,
but I can't come up
Ovid wrote on 09.05.2010 15:33:
My apologies. This isn't PG-specific, but since this is running on
PostgreSQL 8.4, maybe there are specific features which might help.
I have a tree structure in a table and it uses materialized paths to
allow me to find children quickly. However, I also need to
Running 8.4.3, I have a table with 43 million rows. Two of the columns are
(topic_id int not null) and (status message_status_enum not null), where
message_status_enum is defined as
CREATE TYPE message_status_enum AS ENUM ( 'V', 'X', 'S', 'R', 'U', 'D' );
Among the indexes there is this:
Gordon Shannon gordo...@gmail.com writes:
- Bitmap Heap Scan on m_20100201 (cost=987806.75..987810.75 rows=1
width=0) (actual time=2340.191..2340.191 rows=0 loops=1)
Recheck Cond: (status = ANY ('{S,X}'::message_status_enum[]))
- Bitmap Index Scan on
Hi,
I'm stumped by an issue we are experiencing at the moment. We have
been successfully archiving logs to two standby sites for many months
now using the following command:
rsync -a %p postg...@192.168.80.174:/WAL_Archive/ rsync
--bwlimit=1250 -az %p postg...@14.121.70.98:/WAL_Archive/
Due to
valentin.hoc...@kabelbw.de (Valentin Hocher) writes:
[ cPanel's Shell Fork Bomb Protection actually does this: ]
ulimit -n 100 -u 20 -m 20 -d 20 -s 8192 -c 20 -v 20
2/dev/null
Just to annotate that: some experimentation I did confirms that on
RHEL5 x86_64, PG 8.4.3
Sorry, version: PostgreSQL 8.4.2 on x86_64-redhat-linux-gnu, compiled
by GCC gcc (GCC) 4.1.2 20071124 (Red Hat 4.1.2-42), 64-bit
On Mon, May 10, 2010 at 5:01 PM, bricklen brick...@gmail.com wrote:
Hi,
I'm stumped by an issue we are experiencing at the moment. We have
been successfully
bricklen brick...@gmail.com writes:
Due to some heavy processing today, we have been falling behind on
shipping log files (by about a 1000 logs or so), so wanted to up our
bwlimit like so:
rsync -a %p postg...@192.168.80.174:/WAL_Archive/ rsync
--bwlimit=1875 -az %p
Thanks for the advice. In that case, I'll stick with the standard
approach of having a single SQL server and several web frontends and
employ a caching mechanism such as memcache as well. Thanks!
Mike
On Mon, May 10, 2010 at 9:30 AM, Scott Marlowe scott.marl...@gmail.com wrote:
On Fri, May 7,
Tom Lane-2 wrote:
My first suspicion
is that those are unvacuumed dead rows ... what's your vacuuming policy
on this database?
Ah, I didn't know that number included dead tuples. That probably explains
it. pg_stat_user_tables says the table has 370,269 dead tuples. On this
table, I
On Mon, May 10, 2010 at 7:04 PM, Mike Christensen m...@kitchenpc.com wrote:
Thanks for the advice. In that case, I'll stick with the standard
approach of having a single SQL server and several web frontends and
employ a caching mechanism such as memcache as well. Thanks!
And with 9.0 it will
Tom Lane wrote:
A look at the code shows that the archiver only notices SIGHUP once
per outer loop, so the change would only take effect once you catch up,
which is not going to help much in this case. Possibly we should change
it to check for SIGHUP after each archive_command execution.
I
On Mon, May 10, 2010 at 7:21 PM, Mike Christensen m...@kitchenpc.com wrote:
Man that sounds awesome. I need that now. So does that mean you'd
have one beefy SQL server for all the updates and everything writes to
that, and then you'd have a bunch of read-only servers and new data
trickles
On Mon, May 10, 2010 at 5:50 PM, Tom Lane t...@sss.pgh.pa.us wrote:
A look at the code shows that the archiver only notices SIGHUP once
per outer loop, so the change would only take effect once you catch up,
which is not going to help much in this case. Possibly we should change
it to check
On Mon, May 10, 2010 at 6:12 PM, Greg Smith g...@2ndquadrant.com wrote:
Tom Lane wrote:
A look at the code shows that the archiver only notices SIGHUP once
per outer loop, so the change would only take effect once you catch up,
which is not going to help much in this case. Possibly we should
The concept of updating one database and doing all your reads from
another database is kinda confusing to me. Does that mean you have to
design your whole app around that concept, have a different connection
string and what not for your writable database and read-only
databases? I'm using Castle
On Mon, May 10, 2010 at 8:00 PM, Mike Christensen m...@kitchenpc.com wrote:
The concept of updating one database and doing all your reads from
another database is kinda confusing to me. Does that mean you have to
design your whole app around that concept, have a different connection
string
Man that sounds awesome. I need that now. So does that mean you'd
have one beefy SQL server for all the updates and everything writes to
that, and then you'd have a bunch of read-only servers and new data
trickles into them from the master continuously?
Mike
On Mon, May 10, 2010 at 6:09 PM,
Scott Marlowe wrote:
Is there any sort of abstraction layer (like in the driver level) that
can abstract that and just make updates go to one DB and reads
round-robin to other DBs? Hopefully there's a way to make this design
simple to implement.
Pretty sure pgpool can do the read from
On Mon, May 10, 2010 at 8:59 PM, John R Pierce pie...@hogranch.com wrote:
Scott Marlowe wrote:
Is there any sort of abstraction layer (like in the driver level) that
can abstract that and just make updates go to one DB and reads
round-robin to other DBs? Hopefully there's a way to make this
On Tue, May 11, 2010 at 9:50 AM, Tom Lane t...@sss.pgh.pa.us wrote:
bricklen brick...@gmail.com writes:
Due to some heavy processing today, we have been falling behind on
shipping log files (by about a 1000 logs or so), so wanted to up our
bwlimit like so:
rsync -a %p
I was wondering, how can I check whether Vacuum operation had been executed
without problem?
I use the following Java code to execute Vacuum operation
final Statement st2 = connection.createStatement();
st2.executeUpdate(VACUUM FULL ANALYZE VERBOSE);
st2.close();
Nothing print out at console.
57 matches
Mail list logo