On Wed, 15 Dec 2010 11:30:14 +0100
Marcin Krol wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hello,
>
> I'll use PG on a dedicated machine with more than 4GB of memory.
>
> The problem is: what would be better to use: PAE ("bigmem" kernels) or
> 64-bit kernel?
>
> PAE pro: half
Why don't you use https://projects.commandprompt.com/public/pgcore ?
This repo provides a fonctionnal postgis rpm, and some more goodies.
If you really want to compile it yourself (bad idea, imho), you'll
need gcc-c++, and a quite a lot other packages.
Laurent.
--
Sent via pgsql-general mailing l
Hello,
I'd try to use postgis ( http://postgis.refractions.net ), that allows
you to geolocalize your data. We use such an extention here for the
same kind of data you use. It will lighten up table size, and queries.
Otherwise, partitioning and cluster are good things to do. I would
increase defau
2008/11/5 Brandon Metcalf <[EMAIL PROTECTED]>:
> We have a number of automated jobs that connect to our pgsql DB and
> I'm wondering what others are doing for authentication and securing
> passwords. It's easy enough to hardcode a password, but is there
> something specific to pgsql, perhaps, that
20 hours to find the fix Teodor, Kudos !
Due to the importance of the fix, will we see very soon a 8.3.5 ?
Regards,
Laurent.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
2008/10/15 Scott Marlowe <[EMAIL PROTECTED]>:
>
> You'll probably have to ask that in -hackers. I'm guessing it's one
> of those things that if one wrote a sufficiently large check one could
> find a hacker to implement it. But I can't imagine it being a weekend
> project, and if it's not already
Hi,
According to the documentation (
http://www.postgresql.org/docs/8.3/interactive/sql-createtrigger.html
), the feaure "SQL allows triggers to fire on updates to specific
columns (e.g., AFTER UPDATE OF col1, col2)" is missing.
After a bit of research, I found that this feature was in the TODO
li