* Matt Magoffin (postgresql@msqr.us) wrote:
Also, by adjusting this, would I possibly just be delaying the problem we
currently have (i.e. over time, we start to run out of memory)? I just
wonder why the system is reaching this limit at all... do you feel it is
quite normal for a system
* Matt Magoffin (postgresql@msqr.us) wrote:
Yes... and indeed changing vm.overcommit_ratio to 80 does allow that
previously-failing query to execute successfully. Do you think this is
also what caused the out-of-memory error we saw today just when a
transaction was initiated?
Almost
* Matt Magoffin (postgresql@msqr.us) wrote:
We've been having persistent out-of-memory errors occur in our production
8.3 deployment, which is now running 8.3.5. I'm not sure the query here is
the cause of the problem, but this is our most-recent example which
triggered an out-of-memory
* Matt Magoffin (postgresql@msqr.us) wrote:
Yep, we've got 16GB to work with here. I should have also mentioned the
architecture in my original post, sorry. SELECT version() returns this:
PostgreSQL 8.3.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC)
4.1.2 20070626 (Red Hat
* Matt Magoffin (postgresql@msqr.us) wrote:
Does the result from 'free' look reasonable on this box?
I think so:
total used free sharedbuffers cached
Mem: 16432296 16273964 158332 0 173536 14321340
-/+ buffers/cache:
* Tom Lane (t...@sss.pgh.pa.us) wrote:
Stephen Frost sfr...@snowman.net writes:
Uhh.. I saw that your system was 64-bit, but is your PG process
compiled as 64bit? Maybe you're hitting an artificial 32-bit limit,
which isn't exactly helped by your shared_buffers being set up so high
* Matt Magoffin (postgresql@msqr.us) wrote:
I think it must be compiled 64-bit, or he'd not be able to get
shared_buffers that high to start with. However, it's possible that the
postmaster's been started under a ulimit setting that constrains each
backend to just a few hundred meg of
* Tom Lane (t...@sss.pgh.pa.us) wrote:
Hmm ... a gig here, a gig there, pretty soon you're talking about real
memory? He's got several sorts and hashes that are each taking over
100MB according to the memory context dump, so it seems impossible that
it all fits into a strict 32-bit address
* Ciprian Dorin Craciun ([EMAIL PROTECTED]) wrote:
Even better might be partitioning on the timestamp. IF all access is
in a certain timestamp range it's usually a big win, especially
because he can move to a new table every hour / day / week or whatever
and merge the old one into a big
Simon,
* Simon Windsor ([EMAIL PROTECTED]) wrote:
Generally, I have avoided using VIEWS within application code and only
used them for client interfaces, the sole reason being the performance
of views against tables.
Views really shouldn't have a large impact on overall performance. In
* 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
* Ivan Sergio Borgonovo ([EMAIL PROTECTED]) wrote:
I'd say because postgresql list has been used to it by a longer time
than most of the new comers doing the other way around did. But it
seems that the new comers are the most vocal.
sigh. First people complain that poor Mikkel is the only one
* 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
* 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
* 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
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
* 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
* 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
* 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
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
* 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
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,
* 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.
* 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
* 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
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
* 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
* 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.
* 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
* 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
* 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
* 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
* 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?
* 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
* 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
* [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
* 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
* 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
* 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
* 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
* 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
* 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
* 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
* 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
* 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
* 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 =
* 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
* 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
* 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?
* 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
* 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
* 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 ...
* 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
* 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
* 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
* 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
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
* 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
* 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
* 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
* 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
* 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..
* 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:
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
* 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. :)
* 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
* 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
* 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
* 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
* 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
* 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
* 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
* 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
* 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
* 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
* [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
* 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
* 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,
* 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
* 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
* 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
301 - 400 of 401 matches
Mail list logo