* [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote:
Unfortunately PostgreSQL performs much slower than MySQL doing large
number of updates for one single table. By its nature ZABBIX requires
to execute hundreds of updates per second for large installations.
PostgreSQL cannot handle this nicely.
If
* Alexander Staubo ([EMAIL PROTECTED]) wrote:
What formula did you use to get to that number? Is there a generic
way on Linux to turn off (controller-based?) write caching?
Just a side-note, but if you've got a pretty good expectation that you
won't be without power for 24 consecutive hours
* Tom Darci ([EMAIL PROTECTED]) wrote:
I've been looking into using the function aclcontains() in conjunction
with the table pg_class, in order to determine which objects a role has
been granted privilges to. And while this seems promising, I'm still not
having any luck formulating the sql
* John D. Burger ([EMAIL PROTECTED]) wrote:
The good thing is that there are several companies supporting
Postgres,
so whatever one of them does it does not affect the market as a whole.
Surely there are also third-party companies that provide support
for MySqueal in some similar sense?
* John McCawley ([EMAIL PROTECTED]) wrote:
(I am working on this project with Derrick.) We have to use the Active
Directory to authenticate not only users from our client-side app (We're
attempting to use PostgreSQL essentially as a proxy authentication
mechanism), but also for connections
* Derrick ([EMAIL PROTECTED]) wrote:
I was wondering if anyone out there could point me in the right
direction. I'm looking for a decent how to on using postgresql's built
in kerberos support to authenticate against windows 2003 active
directory. I was trying to use pam_ldap, but had to
* Joshua D. Drake ([EMAIL PROTECTED]) wrote:
Without that, I might have even filed it away in case I needed what they
were offering (24/7 phone support is useful for those of us in vastly
different time zones).
http://www.commandprompt.com/ :) We are more cost effective and have
been
* Kynn Jones ([EMAIL PROTECTED]) wrote:
Hi! I am in the process of writing a PostgreSQL lexer/parser in Perl,
because everything else I've found in this area is too buggy. I'm
basing this lexer/parser on the lexer and parser encoded respectively
in scan.l and gram.y under src/backend/parser.
* Gauthier, Dave ([EMAIL PROTECTED]) wrote:
stdb=# select myfunc();
ERROR: set-valued function called in context that cannot accept a set
select * from myfunc(); ?
Stephen
signature.asc
Description: Digital signature
* [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote:
Since I'm not an expert in Postgres database design, I'm assuming I've
done something sub-optimal. Are there some common techniques for
tuning postgres performance? Do we need beefier hardware?
Honestly, it sounds like the database design might be
* [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote:
I am running three ways: sequential scan, bitmap index scan and index scan.
The I/O cost for the index scan is 24+ times more than the other two. I do
not
understand why this happens. If I am using a clustered index, it is my
understanding
* Narasimha Rao P.A ([EMAIL PROTECTED]) wrote:
Does postgreSQL support distributive query processing?
PostgreSQL does not directly support splitting one query across multiple
nodes (cpus, machines, whatever). It's certainly possible to set up
distributed load balancing over some set of
* Tom Lane ([EMAIL PROTECTED]) wrote:
If you're worried about having the system insecure even transiently
against local bad guys, it's possible to do this without opening any
hole, but it requires taking the DB down for a few minutes so you can
do the password change in standalone mode.
An
Tony,
* Tony Caduto ([EMAIL PROTECTED]) wrote:
You guys really should keep such kind words to yourself. Not sure how in
the hell you can say its bad code when it is just a little piece. You don't
even know what it does.
Erm, I'm pretty confident Tom knows exactly what it does. It's not
* Wayne Johnson ([EMAIL PROTECTED]) wrote:
Is there a way to do this automatically? Say, to make all new objects
accessible (or even owned) by a group? Something like the sticky bit in
a directory on UNIX.
8.1 is expected to have Roles support in it, which merges users and
groups into one
* Richard Hayward ([EMAIL PROTECTED]) wrote:
Is there any way of getting the user?
You might try session_user. 8.1 will hopefully clean this up some.
Thanks,
Stephen
signature.asc
Description: Digital signature
* Peter Eisentraut ([EMAIL PROTECTED]) wrote:
Stephen Frost wrote:
* Richard Hayward ([EMAIL PROTECTED]) wrote:
Is there any way of getting the user?
You might try session_user. 8.1 will hopefully clean this up some.
Why would it? This is SQL standard behavior that should
* Joe Maldonado ([EMAIL PROTECTED]) wrote:
It seems that TRUNCATE is first posting a lock on the table and then
waiting for other transactions to finish before truncating the table
thus blocking all other operations.
Is this what is actually going on or am I missing something else? and is
* Stephan Szabo ([EMAIL PROTECTED]) wrote:
On Fri, 19 Aug 2005, Bernard wrote:
My suggestions for improving the COPY command so it can be used by
non-superuser users would be as follows:
If you want to do this without switching to a different UNIX user, can't
you already write a small
* Ben ([EMAIL PROTECTED]) wrote:
Oracle has a very handy function called first_value, which can be used
to turn a set like this:
a 10
a 3
b 1
c 30
c 10
d 1
d 20
...into this:
a 10
b 1
c 30
d 1
Does postgres have something equivalent, or, even better,
* Ben ([EMAIL PROTECTED]) wrote:
Sweet, indeed it is. DISTINCT ON seems to be a postgresism, but I can
live with that.
Uhhh, I was pretty sure it was standard SQL... I'd have to go look it
up though, to be sure.
Don't forget to order by to make sure you get something consistent. :)
* Tom Lane ([EMAIL PROTECTED]) wrote:
Stephen Frost [EMAIL PROTECTED] writes:
* Ben ([EMAIL PROTECTED]) wrote:
Sweet, indeed it is. DISTINCT ON seems to be a postgresism, but I can
live with that.
Uhhh, I was pretty sure it was standard SQL...
Nope, definitely a Postgres-ism.
Huh
* Aly S.P Dharshi ([EMAIL PROTECTED]) wrote:
- What is the status of those items listed on the PostgreSQL gotchas
- Are they bugs ?
- Are they valid statements ?
- If they are bugs are they resolved ?
- What does the PG community thing of this list of gotchas ?
* Tom Lane ([EMAIL PROTECTED]) wrote:
Matthew matthew@zeut.net writes:
Is it worth having a GUC variable that enables / disable this?
That's a given, I think. We're certainly not going to make smash-to-
lower-case the only available behavior.
A GUC variable for this would be quite nice..
* Apu Islam ([EMAIL PROTECTED]) wrote:
I need suggestion to backup my postgresql server. The database is growing
1/2 Gb a day and I am looking for a solution that would push the data off to
the backup server periodically with minimal amount of load to the server (I
am trying to avoid table
* Kenneth Downs ([EMAIL PROTECTED]) wrote:
We use real database users in our systems, we don't connect in with an
over-endowed user and then arbitrate security in client code.
Therefore, we depend entirely upon the server's ability to enforce security.
We do the same thing. :)
The
* Kynn Jones ([EMAIL PROTECTED]) wrote:
Now, supposing we have a fresh batch of host registration requests
that have passed all the filters we may impose on them (i.e. they have
been approved somehow). How best to automate the process of
granting access to these host? I suppose that the
* Kynn Jones ([EMAIL PROTECTED]) wrote:
On 3/15/07, Stephen Frost [EMAIL PROTECTED] wrote:
* Kynn Jones ([EMAIL PROTECTED]) wrote:
One big question I have is, is this completely read-only?
Sorry, I should have made this clear: the access we had in mind is
strictly read-only, and only
* Joshua D. Drake ([EMAIL PROTECTED]) wrote:
We have considered getting Polos as well as normal shirts. The normal
shirts are your basic 6.1 oz 100% cotton. No iron required, heavy
enough to hide the extra we all get once we get over 30. The main issue
with polo's is that they are expensive
* Marek Lewczuk ([EMAIL PROTECTED]) wrote:
I'm looking for a C developer that is able to rewrite pl/pgsql functions to
PostgreSQL c functions - because we need better performance we would like
to have all important functions rewritten to c (looking from pl/pgsql point
of view they are not
* Afakeo Nameo ([EMAIL PROTECTED]) wrote:
I am looking for any information regarding the approval of PostgreSQL by any
United States government entities. I am specifically looking for approval
on a DOD (Department of Defense) or DADMS (Defense Automated Document
Management System) list.
Ken,
* Ken Johanson ([EMAIL PROTECTED]) wrote:
But given the recent and dramatic example of 8.3's on-by-default stricter
typing in functions (now not-autocasting), I worry that kind of change
could happen in every minor version (8.4 etc).
8.3 isn't a minor version.
Enjoy,
* F. Jovan Jester ([EMAIL PROTECTED]) wrote:
1. a - old notation
2. a
3. e d
4. b c
*blink*
hmm. How about 1 and 2?
(is this an April fools joke?)
Stephen
signature.asc
Description: Digital signature
* David Fetter ([EMAIL PROTECTED]) wrote:
On Thu, Jan 27, 2005 at 02:14:32PM -0500, Rick Schumeyer wrote:
Is there a way to import mdb files from Access into pg?
I found a web page for mdbtools but I can't get it to compile.
Here are a couple of ways to approach the problem:
1. Use
* Joshua D. Drake ([EMAIL PROTECTED]) wrote:
Rick Schumeyer wrote:
Is there a way to import mdb files from Access into pg?
I would use ODBC to create linked tables from Pg and copy from the unlinked
mdb tables.
I've tried doing thing and discovered that for large tables it can be
quite
* David Parker ([EMAIL PROTECTED]) wrote:
As part of our application we are running a postgres server on a RAM
disk. All of the data stored in this database is obviously disposable,
and we need to optimize access as much as possible. This is on Solaris
9/intel, postgres 7.4.5. Some things I'm
* Mark Steckel ([EMAIL PROTECTED]) wrote:
So, if you have used Postgres (or know that it has been used) for a
government project, especially in a 24x7 environment, I would greatly
appreciate hearing about it. Ideally, I need more than just the project
name. Specifically, A brief description
* Johnson, Shaunn ([EMAIL PROTECTED]) wrote:
--i had tried to use 'copy', but it was taking
--so long ... it took over a weekend to load
--about the same amount of records as using 'insert' (i have
--been running this program for over 2 days and only
--have 2800 records to show out of 1/2 a
* Johnson, Shaunn ([EMAIL PROTECTED]) wrote:
--how did you use copy to move data?
I set up the Ora2Pg object using the appropriate settings, dumped all
the tables out to a file and then did psql file. 2 million or so rows
across a bunch of tables, didn't take too long.
Stephen
* Oliver Elphick ([EMAIL PROTECTED]) wrote:
On Tue, 2003-11-18 at 12:59, Peter Eisentraut wrote:
Oliver Elphick writes:
Please note that the python packages have been dropped from this build,
since the PyGreSQL source tree is now independent. Another maintainer
will take those on.
* Oliver Elphick ([EMAIL PROTECTED]) wrote:
On Tue, 2003-11-18 at 13:19, Stephen Frost wrote:
plr needs to build in the source tree, so the easiest way to do that is
to include it in the source. The same goes (or did go) for the others.
I don't think this is really the case. I
* Thomas Holmgren ([EMAIL PROTECTED]) wrote:
I have a large number of clients synchronizing with a central database.
The clients update their local data by polling the database for changes
at fixed intervals. I need an efficient way of determining if data in a
table has been changed (either
* Nick Barr ([EMAIL PROTECTED]) wrote:
http://postgis.refractions.net
I second this recommendation. Additionally, consider checking out
GDAL, ogr2ogr and the TIGER dataset provided by the US Census (if you're
in the US anyway). It provides information about basically all the
streets,
* David Garamond ([EMAIL PROTECTED]) wrote:
What do people think of adding some more aggregate functions. These are
the ones that MySQL has and PG doesn't:
- STD/STDDEV
- VARIANCE
- BIT_OR
- BIT_AND
- GROUP_CONCAT (for strings, added in MySQL 4.x)
[...]
Btw, I have written 1 or 2 of the
* [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote:
DB2, as far as I know, uses some precompiled SQL files which may make a
difference if used or not used.
Is it much of one if you're using prepared statements? I guess it
depends on how many different queries you do.
Stephen
* Assad Jarrahian ([EMAIL PROTECTED]) wrote:
[EMAIL PROTECTED]:/etc/postgresql-common$ sudo pg_upgradecluster 8.0 main
Error: target cluster 8.1/main already exists
This is complaining that you already did an initdb on the 8.1 version, I
believe.
What would be the step by step process in this
* Philippe Ferreira ([EMAIL PROTECTED]) wrote:
But, I'm wondering what could be the behaviour of Postgresql if you
shutdown the
service while a new WAL archive is just ready to be copied, or if the
transfer is in
progress...
Will the tranfer be canceled (until the next start), or will
* Tom Lane ([EMAIL PROTECTED]) wrote:
Richard van den Berg [EMAIL PROTECTED] writes:
Is there a good reason that the official RPM on postgresql.org is not
build with HAVE_INT64_TIMESTAMP ? It would have been so nice if this
would have worked. :-/
You've got that 100% backwards: you
on the default setting.
[...]
If Tom could present an actual reason why it shouldn't be enabled, I'm sure
Martin (Pitt) would be interested. But Stephen Frost and Peter
Eisentraut as well as others seem to be suggesting that Debian default is
sane.
I think what Peter said is probably correct
* Russ Brown ([EMAIL PROTECTED]) wrote:
Oh, that's a long story. We're a MySQL house that I've been trying to
convert to PostgreSQL one way or the other for ages (with no success as
yet). Note that the argument isn't about which letter the type
truncation applies to, but whether it actually
* Pete Deffendol ([EMAIL PROTECTED]) wrote:
Correct me if I'm wrong, but it seems that PostgreSQL 7.4 does not remove a
user's privileges on tables when that user is dropped. The privileges are
still showing up if I do a \z in psql, but with the SYSID instead of the
username (obviously, since
* Tom Lane ([EMAIL PROTECTED]) wrote:
Benjamin Smith [EMAIL PROTECTED] writes:
What's the best way to do this? Take PG down (normally started as a
service)
and run directly in a single-user mode?
No, just start a psql session in one window, then in another window
determine the PID of
* Florian Weimer ([EMAIL PROTECTED]) wrote:
* Redefined Horizons:
It looks like the packages.debian.org site is down. Is there another
place where I can download a .deb for the latest stable version of
PostgreSQL. (I don't have a direct link to the internet on my Linux
box, so I can't
* David Rio Deiros ([EMAIL PROTECTED]) wrote:
Now I have to redefine my query because I want to get the second
output but keeping the group_id. Ideas and suggestions are welcome.
You might want to look at 'distinct on'.
Stephen
signature.asc
Description: Digital signature
* Nina ([EMAIL PROTECTED]) wrote:
I think you maybe familiar with this command:
psql -At -F , -c select ... query.csv
My question is:
is it possible to export several different columns from different
tables into the same .csv file; something like: psql -At -F , -c
select ... select ...
* Marc G. Fournier ([EMAIL PROTECTED]) wrote:
As of this moment, if Oracle buys Zend, they could effectively kill PHP
... the core engine that PHP is built around is a Zend engine, so if they
were to revoke the license for that, PHP would be dead ... kinda like
MySQL with InnoDB ... now,
* Marc G. Fournier ([EMAIL PROTECTED]) wrote:
On Tue, 14 Feb 2006, Stephen Frost wrote:
Has there been any actual test (ie: court case) of a piece of software
being released under an open source (BSD, GPL, whatever) license and
then the licensor revoking that and stopping everyone from
* Chad ([EMAIL PROTECTED]) wrote:
course the product you own is called MySQL. Do MySQL or any MySQL
customers need a commercial license for BDB? I think not. MySQL does
not as all its code is open source. As for MySQL customers, unless they
are making direct API calls into BDB (which most
* Emi Lu ([EMAIL PROTECTED]) wrote:
We have millions of record and would like to insert into a table. I
remebered people mentioned that COPY is the most effecient way to
insert data, right? If not, which is it, pg_restore?
By the way, does it have to be superuser to run copy to and from?
* Bruno Wolff III ([EMAIL PROTECTED]) wrote:
On Mon, Mar 13, 2006 at 17:50:44 -0600,
Kevin Grittner [EMAIL PROTECTED] wrote:
Short of being compelled by law to open our records, I'm not
comfortable providing any performance comparison which names the
vendor.
An open records request
* Bruno Wolff III ([EMAIL PROTECTED]) wrote:
On Tue, Mar 14, 2006 at 23:27:24 -0500,
Stephen Frost [EMAIL PROTECTED] wrote:
About which vendors they use and what contracts they have and you might
be able to figure out which vendors have such a clause. I don't know
that such a request
* Harco de Hilster ([EMAIL PROTECTED]) wrote:
ERROR: FULL JOIN is only supported with merge-joinable join conditions
I'm not a big fan of that error either, honestly.
select *
from A
full outer join B on A.f1 = B.f1 and ((A.ExpTime IS NULL AND B.ExpTime
IS NULL) OR (A.ModTime =
* Tom Lane ([EMAIL PROTECTED]) wrote:
[EMAIL PROTECTED] [EMAIL PROTECTED] writes:
Am I correct in assuming that when Postgres prepared the SQL to execute
the insert function that the existing rules on the base table were
also resolved at that time? If so, is there any way to avoid that
* Todd P Marek ([EMAIL PROTECTED]) wrote:
I have looked through the documentation and haven't found anything to
do this in postgres. I am going to have to do this formating in the
application layer?
If nothing else I'd think you could create your own function in Postgres
to display the time
* Oliver Elphick ([EMAIL PROTECTED]) wrote:
Twits like you make me proud to be a Brit.
Gee, I wonder if it was forged...?
[EMAIL PROTECTED]
Yup.
Stephen
signature.asc
Description: Digital signature
* Stephan Szabo ([EMAIL PROTECTED]) wrote:
On Mon, 6 Dec 2004, Per Jensen wrote:
select count(*)
from accesslog
where time between (timeofday()::timestamp - INTERVAL '30 d') and
timeofday()::timestamp;
Besides the type issue, timeofday() is volatile and thus is not allowed to
be
* Tom Lane ([EMAIL PROTECTED]) wrote:
Tyler MacDonald [EMAIL PROTECTED] writes:
OK, I'm kind of confused about how the legal red tape works here.
Debian packages all sorts of GPL code, and both openssl and postgres are
released under more liberal licenses. About the only legal issue I
* Tom Lane ([EMAIL PROTECTED]) wrote:
Stephen Frost [EMAIL PROTECTED] writes:
Or are they selectively enforcing this
policy against PG?
It's enforced whenever we discover it, really...
I am strongly tempted to pull Debian's chain by pointing out that
libjpeg has an advertising clause
* Chris Travers ([EMAIL PROTECTED]) wrote:
It says, in no
uncertain terms, that GPL programs must come with complete source of
themselves and all dependancies under terms compatible with the GPL.
The advertising clause in OpenSSL is not acceptable.
No it doesn't. Otherwise you couldn't
* Tom Lane ([EMAIL PROTECTED]) wrote:
Stephen Frost [EMAIL PROTECTED] writes:
The courts are pretty likely to strongly consider the copyright holder's
opinion of the license when deciding how to interpret it.
It's worth pointing out here that
1. Debian is not the copyright holder
* Florian G. Pflug ([EMAIL PROTECTED]) wrote:
I can do that with alter user user set role whatever too...
But I'd like my users to be able to connect as either role dev or
role admin, depending on the task they want to do.
Alright, can you describe *exactly* what you'd want to see then? Is
* Florian G. Pflug ([EMAIL PROTECTED]) wrote:
I'd like to be able to connect to postgres, and automatically assume a
specific role.
Couldn't you just have 'SET ROLE whatever' in the user's .psqlrc? At
least, if that's how they're connecting I think that'd work...
Enjoy,
* Florian G. Pflug ([EMAIL PROTECTED]) wrote:
Stephen Frost wrote:
Alright, can you describe *exactly* what you'd want to see then? Is
this a new command-line option to psql (perhaps something like -v?)? Or
do you need it to be supported by libpq through a new connect-string
option
* Ari Kahn ([EMAIL PROTECTED]) wrote:
That was a good idea. But this is not the case.
You might try just looking at pg_database directly:
select * from pg_database;
Or (as someone else suggested) pipeing the output into a file which
you can then look at.
As a side-note: I'm a graduate
* Tony Lausin ([EMAIL PROTECTED]) wrote:
Ahh. I see the point more clearly now. Perhaps the best strategy for
me is to press on with Postgres until the project is at a profitable
enough stage to merit a migration to Oracle - should Postgres become
an issue. I feel more confident about being
* Florian G. Pflug ([EMAIL PROTECTED]) wrote:
I'd like to implement that scheme, but am unsure how
to determine that segment reliably. I noticed that
there is an pg_xlog/archive_status directory, which
contains *.done files for some of the archived wal logs.
Personally, I was just lazy and
* Steve Atkins ([EMAIL PROTECTED]) wrote:
If we were playing DNS body part size wars then who has the bigger
DNS clue might be relevant. We're not, though. Rather I'm saying that
publicly criticizing people who volunteer services to a project,
about things that are not related to the
* Arturo Perez ([EMAIL PROTECTED]) wrote:
Any response to this:
http://www.internetnews.com/dev-news/article.php/3631831
Turn fsync off and try again. Don't expect your data to stay consistant
tho.
Enjoy,
Stephen
signature.asc
Description: Digital signature
Bill,
* Bill Moran ([EMAIL PROTECTED]) wrote:
In response to Bill Moran [EMAIL PROTECTED]:
If I have a database called db1 to which the role dumpable has enough
permissions to do a full pg_dump, but he user joe does not, how can
joe do a pg_dump? Is it possible?
Apologies, I left out a
* John D. Burger ([EMAIL PROTECTED]) wrote:
My understanding is that PG will use an index on the referring side of a
foreign key for FK checks. How can I tell whether it's doing that?
It should, when it makes sense, yes. Having the actual schema
definitions would help in debugging this, of
* Ragnar ([EMAIL PROTECTED]) wrote:
On mið, 2008-07-30 at 07:36 -0400, Kevin Hunter wrote:
At 3:45p -0400 on Mon, 28 Jul 2008, Said Ramirez wrote:
According to the documentation,
http://www.postgresql.org/docs/current/interactive/sql-truncate.html ,
only the owner can truncate a
* Scott Marlowe ([EMAIL PROTECTED]) wrote:
Aug 9 13:13:21 engelberg kernel: [71242.735046]
Does this look like a kernel bug or a pgsql bug to most people?
It's certainly something kernel-related. It might be the OOM killer
though.. You might want to disable that. Is the box running out of
* Scott Marlowe ([EMAIL PROTECTED]) wrote:
I take that back. This problem followed the RAID card from one
machine to another.
That's certainly curious. The kernel backtrace didn't seem to have
anything terribly interesting in it (at least to me). Sure there aren't
more detailed logs? With
Greg,
* Greg Lindstrom ([EMAIL PROTECTED]) wrote:
I would like to connect to Postgres from Python running on a Windows box. I
need the ODBC driver to create a windows ODBC datasource. I've been looking
for two days and have found lots of dead links, but no drivers. Can someone
please help
* Bill Todd ([EMAIL PROTECTED]) wrote:
FWIW I cannot get the ODBC driver to work correctly with ADO and the OLE
DB provider for ODBC. It sees TEXT fields as VARCHAR instead of
LONGVARCHAR. I do not know if the problem is at the ODBC level or the
ADO level but test carefully if you are
* Mikkel Høgh ([EMAIL PROTECTED]) wrote:
I have been testing it a bit performance-wise, and the numbers are
worrying. In my test, MySQL (using InnoDB) had a 40% lead in
performance, but I'm unsure whether this is indicative for PostgreSQL
performance in general or perhaps a
* Tom Lane ([EMAIL PROTECTED]) wrote:
We do have a TODO item to allow type date to do that too. It's been asked
for often enough, not sure why it hasn't happened. Seems easy enough,
maybe I'll go do it.
It's certainly be useful for us..
Thanks,
Stephen
* Tomasz Ostrowski ([EMAIL PROTECTED]) wrote:
There is an issue report with lengthy discussion on drupal.org:
http://drupal.org/node/196862
And a proposed patch:
http://drupal.org/files/issues/drupal_lookup_path-5.x.patch.txt
which uses limit 1. This patch is not applied though. I don't know
* DelGurth ([EMAIL PROTECTED]) wrote:
Seems Tomasz linked to the wrong patch. The patch he meant was:
http://drupal.org/files/issues/drupal_lookup_path-6.x.patch.txt
That's much better.
Also nice to see people benchmark differences by just executing a
query once[2][3]
This thread is
* Bill Moran ([EMAIL PROTECTED]) wrote:
You can resent it or not, but this _is_ a personal thing. It's personal
because you are the only one complaining about it. Despite the large
number of people on this list, I don't see anyone jumping in to defend
you.
Ugh. No one else is jumping in
* Scott Marlowe (scott.marl...@gmail.com) wrote:
On Tue, Apr 21, 2009 at 1:15 PM, Peter Childs peterachi...@gmail.com wrote:
Hmm Interestingly OSM have just switched from MySQL to PostgreSQL.
On the news blog page it mentioned switching to MonetDB. I saw
nothing about pgsql there. Do they
* Scott Marlowe (scott.marl...@gmail.com) wrote:
On Tue, Apr 21, 2009 at 1:15 PM, Peter Childs peterachi...@gmail.com wrote:
Hmm Interestingly OSM have just switched from MySQL to PostgreSQL.
On the news blog page it mentioned switching to MonetDB. I saw
nothing about pgsql there. Do they
Greetings,
* Intengu Technologies (sindile.bi...@gmail.com) wrote:
What I would like to do is
If field1=1 make table1 and insert the rest of field1=1 into this table
If field1=2 make table2 and insert the rest of field1=2 into this table
Hence in this example one will have table1, table2,
* Grzegorz Jaśkiewicz (gryz...@gmail.com) wrote:
On Mon, May 25, 2009 at 4:12 PM, Stephen Frost sfr...@snowman.net wrote:
This currently can't be done with the COPY command directly. There are
I would put it in postgresql as is, and than do CREATE TABLE foo AS
SELECT CASE ... END
* Assaf Lavie (assafla...@gmail.com) wrote:
Can anyone please shed light on the difference between the two:
http://stackoverflow.com/questions/1023229/spatial-data-in-postgresql
(login _not_ required)
Without really good justification to use something else, I'd strongly
recommend using
* Janet Jacobsen (jsjacob...@lbl.gov) wrote:
If they are going to spend 95% of their time querying the
records that meet the 'good' criteria, what are the good
strategies for ensuring good performance for those queries?
(1) Should I partition the table into two partitions based on
the value
* Janet Jacobsen (jsjacob...@lbl.gov) wrote:
I looked at the documentation for partitions - it is the case, right, that I
have to create the master table and the two partition tables (depending
on the value of rbscore) and then copy the records from the existing
table into the two partitions?
* Gauthier, Dave (dave.gauth...@intel.com) wrote:
In linux, given the linux based uid of the user, how might someone implement
column level update restrictions on a uid basis? For example...
The first issue is getting the linux uid to equate to a PG role. That
can be done using 'ident'
* David Fetter (da...@fetter.org) wrote:
On Tue, Oct 06, 2009 at 09:57:39AM +0100, Tim Bunce wrote:
http://blog.timbunce.org/2009/10/05/wishlist-of-plperl-enhancements-for-postgresql-8-5/
Is someone working on adding the pl/perl hooks to be called as an
anonymous PG function?
* Rodrigo E. De León Plicet (rdele...@gmail.com) wrote:
Any comments?
Sure, they've never bothered to actually look at the data. Consider
that for quite a while Oracle essentially refused to admit that their
could *possibly* be bugs in their system (see: Unbreakable Linux, or
whatever that
1 - 100 of 401 matches
Mail list logo