On 19/08/12 17:50, Chris Travers wrote:
On Sat, Aug 18, 2012 at 9:30 PM, Gavin Flower
gavinflo...@archidevsys.co.nz mailto:gavinflo...@archidevsys.co.nz
wrote:
On 18/08/12 20:05, Bartel Viljoen wrote:
[...]
I’m in the design faze of a new GUI and DB layout, what are my
Sorry for the lack of a more appropriate title.
The summary of my problem is: i run a query and I get some results; then I
create a view using this query, and I run the same query on the view, and
get different results. Details follow.
On the original table the analytical data is as follows:
#
On Wed, 2012-07-18 at 14:33 -0700, Scott Bailey wrote:
I'm testing range types and I've come up with a couple of curiosities.
1) I'll start off easy. In the wild, discrete ranges tend to be
closed-closed [] while continuous ranges tend to be closed-open [). For
instance, on Tuesday stock
On Thu, Aug 16, 2012 at 04:04:48PM +0200, Wolfgang Keller wrote:
I could not get the script sqlalchemy_schemadisplay3.py to work with
sqlalchemy 0.7.8-1 (on Debian).
Have you asked on the SQLalchemy mailing list?
No.
Thanks for the link.
Regards
Johann
--
Johann Spies
Hello Guys,
I am having a scenario close to the one below, I have defined a function which
depends on a view. I am able to drop the view, but my server did not complain
about the dependency.
In the scenario below, one can drop the views a2 and a1 respectively, and when
executing a3(),
salah jubeh s_ju...@yahoo.com wrote:
Hello Guys,
I am having a scenario close to the one below, I have defined a function which
depends on a view. I am able to drop the view, but my server did not complain
about the dependency.
In the scenario below, one can drop the views a2 and a1
On Sun, Aug 19, 2012 at 8:14 AM, Dmitriy Igrishin dmit...@gmail.com wrote:
For various reasons, this often goes the wrong way. Views are often
the right way to go. +1 on your comment above -- the right way to do
views (and SQL in general) is to organize scripts and to try and avoid
managing
Hello Andreas,
Thanks for the reply, The example I have posted is very simple and you are
right it is very similar to select max (id) from table_that_does_not_exist;
But there are more here, for example imagine I have something like
CREATE VIEW a4 as select from a3(), ;
In my
On Mon, Aug 20, 2012 at 9:37 AM, salah jubeh s_ju...@yahoo.com wrote:
Hello Andreas,
Thanks for the reply, The example I have posted is very simple and you are
right it is very similar to select max (id) from table_that_does_not_exist;
But there are more here, for example imagine I have
salah jubeh s_ju...@yahoo.com wrote:
Hello Andreas,
Thanks for the reply, The example I have posted is very simple and you are
right it is very similar to select max (id) from table_that_does_not_exist;
But
there are more here, for example imagine I have something like
CREATE VIEW a4
On Mon, Aug 20, 2012 at 9:59 AM, Andreas Kretschmer
akretsch...@spamfence.net wrote:
salah jubeh s_ju...@yahoo.com wrote:
Hello Andreas,
Thanks for the reply, The example I have posted is very simple and you are
right it is very similar to select max (id) from table_that_does_not_exist;
Thalis Kalfigkopoulos tkalf...@gmail.com writes:
# SELECT id, experiment, first_value(insertedon) OVER (PARTITION BY score,
id) AS first_insertedon, score FROM data WHERE id=1160;
[ versus ]
# CREATE VIEW clustered_view AS SELECT id, experiment,
first_value(insertedon) OVER (PARTITION BY
On Fri, 17 Aug 2012 08:53:05 -0400
Moshe Jacobson mo...@neadwerx.com wrote:
I do not know of anything that can't be done from within psql.
We use non-privileged user roles in postgres for day-to-day
operations. When I need to modify the schema, I become postgres (you
can do \c - postgres) and
I vaguely remember reading in the release notes (around the time 9.x was
released) something about it automatically clearing out the postmaster.pid file
if it was found to be stale/invalid when starting the the database server,
however I cannot find any reference to this anymore.
Was this
On Aug 19, 2012, at 8:01 PM, Scott Marlowe scott.marl...@gmail.com wrote:
On Tue, Jul 10, 2012 at 1:09 AM, Steven Schlansker ste...@likeness.com
wrote:
I'm using Postgres hash indices on a streaming replica master.
As is documented, hash indices are not logged, so the replica does not have
On Aug 19, 2012, at 2:37 PM, Jeff Davis pg...@j-davis.com wrote:
On Tue, 2012-07-10 at 00:09 -0700, Steven Schlansker wrote:
I understand that the current wisdom is don't use hash indices, but
(unfortunately?) I have benchmarks that
show that our particular application is faster by quite a
Sebastien Boisvert sebastienboisv...@yahoo.com writes:
I vaguely remember reading in the release notes (around the time 9.x was
released) something about it automatically clearing out the postmaster.pid
file if it was found to be stale/invalid when starting the the database
server, however
Hi,
I am using PostgreSQL 9.1 and loading very large tables ( 13 million
rows each ). The flat file size is only 25M. However, the equivalent
database table is 548MB. This is without any indexes applied and auto
vacuum turned on. I have read that the bloat can be around 5 times
greater
On Mon, Aug 20, 2012 at 10:29 AM, Steven Schlansker ste...@likeness.com wrote:
On Aug 19, 2012, at 2:37 PM, Jeff Davis pg...@j-davis.com wrote:
On Tue, 2012-07-10 at 00:09 -0700, Steven Schlansker wrote:
show that our particular application is faster by quite a bit when a
hash index is
On 08/20/12 10:53 AM, elliott wrote:
Hi,
I am using PostgreSQL 9.1 and loading very large tables ( 13 million
rows each ). The flat file size is only 25M. However, the equivalent
database table is 548MB. This is without any indexes applied and auto
vacuum turned on. I have read that the
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of elliott
Sent: Monday, August 20, 2012 1:54 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Database Bloat
Hi,
I am using PostgreSQL 9.1 and loading very
envdb=# \d astgtm2_n60e073;
Table public.astgtm2_n60e073
Column | Type | Modifiers
+-+---
lat| real|
lon| real|
alt| integer |
Indexes:
q3c_astgtm2_n60e073_idx btree (q3c_ang2ipix(lon, lat)) CLUSTER
On 8/20/2012 2:10 PM, John R Pierce
On Sun, Aug 19, 2012 at 06:28:57PM -0700, Chris Travers wrote:
In DB2 this might be done like:
SELECT * FROM address WHERE address-country-short_name = 'US';
I like DB2's approach better because there is no ambiguity between
namespace resolution but I don't entirely like the way the refs
On 08/20/12 11:46 AM, elliott wrote:
envdb=# \d astgtm2_n60e073;
Table public.astgtm2_n60e073
Column | Type | Modifiers
+-+---
lat| real|
lon| real|
alt| integer |
Indexes:
q3c_astgtm2_n60e073_idx btree (q3c_ang2ipix(lon, lat)) CLUSTER
Howdy folks,
Does anyone know if its possible to use entity framework code first with
the npgsql connector? I know devart's connector does the job, but I'm low
on funds for this project and their stuff is not cheap.
Any help would be appreciated.
On Mon, Aug 20, 2012 at 2:33 PM, John R Pierce pie...@hogranch.com wrote:
On 08/20/12 11:46 AM, elliott wrote:
envdb=# \d astgtm2_n60e073;
Table public.astgtm2_n60e073
Column | Type | Modifiers
+-+---
lat| real|
lon| real|
alt| integer |
On 08/21/2012 03:06 AM, Martijn van Oosterhout wrote:
I'm not sure I have an opinion on pushing ORM features to the database
layer, SQLAlchemy is doing a pretty good job for me already.
There are some things ORMs could really use help from the database with,
though. Particularly when fetching
Is this mechanism documented anywhere (besides source code)?
It looks like PG will only clean it up if there's no other process running at
all on the pid listed in the postmaster.pid file, even if any process running
on that pid isn't a PG process or there's no server running on the data
Sebastien Boisvert sebastienboisv...@yahoo.com writes:
Is this mechanism documented anywhere (besides source code)?
No, not really.
It looks like PG will only clean it up if there's no other process running at
all on the pid listed in the postmaster.pid file, even if any process running
on
Hello,
Since Amazon has added new high I/O instance types and EBS volumes, anyone
has done some benchmark of PostgreSQL on them ?
http://perspectives.mvdirona.com/2012/07/20/IOPerformanceNoLongerSucksInTheCloud.aspx
Hi Tom,
and thanks for the reply (I had the pleasure of meeting you 11 years ago in
Pittsburgh; still a pleasure seeing your concise and helpful replies.)
In the end I went for a change of window function. Using min(insertedon)
instead of first_value(insertedon) works correctly.
Alternatively
31 matches
Mail list logo
