This delete runs in a single transaction. That means the entire transaction
has to complete before you will see anything deleted. Interrupting the
transaction simply rolls it back, so nothing is deleted.
Tom already pointed out the potential foreign key slowdown, another slowdown
may simply be
How accurate do you need it? My website has a lot of local listing stuff
based on a distance from the viewer and I use the earthdistance module in
contrib to do it.
Given, it's not accurate enough to calculate a surgical missile strike, but
for within 20 miles type of things it's good enough
Hi:
I notice when I save a view, I lose all the formatting and comments.
As I was writing a complicated view, wanting to retain the format and
comments, I thought I could just save it as a function that returns a
table value. A function would evaluate to the same value as a view,
but
I have this tables
Table: Contact
IdContact
First Name
Second Name
… other columns
Table: Employee
IdEmployee
IdContact, related to Contact table
… other columns
Table: Salesman
IdSaleman
IdEmployee, if salesman is employee, related to Employee table
IdContact, if salesman
Hi, everyone. Uwe wrote:
What kind of client are the users using? I assume you will have some
kind of user interface. For me this is a typical job for a user
interface. The number of letters with equivalents in different
languages are extremely limited, so a simple matching routine in
Hi, everyone. I'm working on a project on PostgreSQL 9.0 (soon to be
upgraded to 9.1, given that we haven't yet launched). The project will
involve numerous text fields containing English, Spanish, and Portuguese.
Some of those text fields will be searchable by the user. That's easy
... you're looking for a non-sql compliant SQL database where a lot of
the data integrity is actually coded in the application :-)
~
First past of your statement I acknowledged, but how is it exactly
that lot of the data integrity is actually coded in the application
~
Take dates for
First, I wonder what kind of technical person would say there are
de-facto truth(s). I thought only politicians would talk like that.
Well, politicians and Microsoft, Oracle etc. :-)
Now, in a sense you are right, I am talking from the background of my
own experiences (and so are you).
~
I have been searching for a PostgreSQL-derived project with a
less-is-best Philosophy. Even though I have read about quite a bit
of PG forks out there, what I have in mind is more like a baseline
than a fork.
~
My intention is not wrapping the same thing in a different package or
http://cglendenningoracle.blogspot.com/2011/06/oracle-vs-postgres-postgre
sql.html
Any comments?
Amusing.
What kind of support is available if we have a problem? What is their
patching schedule to address exploits and known security defects? If
there is a bug, how responsive
On 06/24/2011 09:14 AM, Rodrigo E. De León Plicet wrote:
I'm quite surprised the article didn't mention the importance of having
somebody to sue if it goes wrong, which is a comment I often see made
re Oracle. It's lucky they didn't try to stress that point, because
evidence of succesful
Hello everyone,
this is very odd, particularly because there's obviously nobody having these
issues when I google for it.
I have a 8.3 database and decided for various reasons to upgrade to 8.4. I also
tried 9.0 - same results.
On the exactly same hardware with the exactly same
Uwe Schroeder u...@oss4u.com writes:
I have a 8.3 database and decided for various reasons to upgrade to 8.4.
I also tried 9.0 - same results. On the exactly same hardware with the
exactly same configuration, some queries perform a factor of 10
slower on 8.4 and 9.0 than on 8.3
Godaddy virtual hosting does in fact support postgresql. You have a root
account on the virtual server and you can install whatever you want.
I run several servers with them and all have postgresql, some virtual, some
dedicated servers.
Haven't tried their shared servers though, so I can't say
Maybe someone here can make sense of this.
I'm trying to upgrade a 8.3 system to a 9.0 system. Usual procedure dump,
restore, vac full, reindex.
Both - old and new - run on the same hardware and the postgresql.conf settings
are identical.
You'll probably ask for the table definitions, which
On 29 January 2011 09:11, Uwe Schroeder u...@oss4u.com wrote:
Maybe someone here can make sense of this.
I'm trying to upgrade a 8.3 system to a 9.0 system. Usual procedure dump,
restore, vac full, reindex.
Both - old and new - run on the same hardware and the postgresql.conf
* Uwe Schroeder (u...@oss4u.com) wrote:
Now I turn off the 8.3 instance and start the 9.0 instance. Remember,
everything is identical. Here the same query again:
Everything isn't identical if you just started PG 9.0 though- presumably
the 8.3 instance had everything cache'd already. What
del
The duration suddenly goes from 270 milliseconds to 173 seconds! The index
scan on bprofile_comments_status_idx suddenly shows 15288 loops, where it
should be 1 loop just like before. So shomehow the 9.0 planner gets it all
wrong.
I also noticed that normally I get an iowait with a
Uwe Schroeder, 26.01.2011 08:34:
I have a query like this:
SELECT a,b,c, (select problem from other_table where id=a) as problem
FROM mytable WHERE a=1
So far so good. Actually problem always resolves to one record, so it's
not the multiple records returned problem.
What I
Google being useless tonight - now that's new :-)
What I'm trying to do is the following and I'm certain there is a simple
solution which eludes me:
I have a query like this:
SELECT a,b,c, (select problem from other_table where id=a) as problem FROM
mytable WHERE a=1
So far so good.
Hi,
Price and features. There are some changes in V12 which is causing us to
do some steps with our support and resellers. We've always wanted to move
away from Sybase so we can make more of a profit off our software and lower
costs for us and our clients. Sybase is a wonderful
In response to Steeles stee...@gmail.com:
new to postgresql. need to backup postgresql DB, which way is better to
backup DB.
from training, I learned that we can backup the whole PGdata and other
directories to achieve backup goal, originally I was planned to schedule
jobs to use
On 25/09/2010 4:55 AM, Leif Biberg Kristensen wrote:
On Friday 24. September 2010 20.04.26 Lincoln Yeoh wrote:
Then again, does Tom ever sleep? Maybe he sleeps in the afternoon? Or
is that when he does intensive coding?
Once there was a suggestion on this list to give Tom every other
I'm working with some people who live and breath Excel. I need to be able
to move data back and forth between formats which make sense for Excel and
for PostgreSQL. In some cases, this is just to accommodate what people are
used to. In other cases, like statistical clustering, it's
Does postgresql have functions to calculate the distance between two
sets of longitude and latitude.
You're looking for the earthdistance contrib module. With most Linux distros
it's installed under /usr/share/postgresql/8.xx/contrib
You may have to install a postgresql-contrib package
On Sunday 08 November 2009 11:38:28 pm Uwe Schroeder wrote:
I've googled, but there's 0 hits.
I have an issue with a ton of idle in transaction backends.
What I noticed is when I look at pg_locks, pretty much all of the processes
being idle in transaction have an exclusive lock of locktype
Personally I prefer multiple stages of backups off-site.
So for my production webserver database, I have slony replicating the database
to a different location. In addition I run full dumps every 12 hours which in
turn I replicate using rdist to a remote system. That way, whatever happens,
the
I've googled, but there's 0 hits.
I have an issue with a ton of idle in transaction backends.
What I noticed is when I look at pg_locks, pretty much all of the processes
being idle in transaction have an exclusive lock of locktype virtualidx.
Well, that doesn't make sense to me, but maybe
28 matches
Mail list logo
