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 eno
> 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,
>
> 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
> IdCont
> 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
> 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
>
> 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
> > ... 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
> ~
> 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
> 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 succes
> > 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, h
> Uwe Schroeder 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 a
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 configuration,
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
> 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 (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 everyt
> On 29 January 2011 09:11, Uwe Schroeder 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
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 I
> 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 recor
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. Actually
> 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 p
> In response to Steeles :
> > 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 pgdump
> 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
> 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 som
> 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 tr
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 s
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 m
28 matches
Mail list logo
