On 20 Oct 2016, at 23:37, Maxim Boguk wrote:
> ​Underscore in like pattern have a special meaning of "any symbol".
> From documentation on the
> https://www.postgresql.org/docs/9.4/static/functions-matching.html :
> "An underscore (_) in pattern stands for (matches) any single character;"
> This
Indexing on a text column:
create index index_documents_on_id_with_pattern_ops (id text_pattern_ops);
This works fine:
> explain select id from documents where id like 'dingbat%';
Index Only Scan using index_documents_on_id_with_pattern_ops on documents
(cost=0.56..8.58 rows=736 wi
On 5/24/08, Ram Ravichandran <[EMAIL PROTECTED]> wrote:
> I am deciding between MySQL and Postgres. I'm leaning towards Postgres
> mainly due the widely publicized speed when using transactions. However, I
> am not able to find any good books / resources for tuning/ optimizing the
> database. Is th
On 2/17/08, Maxim Khitrov <[EMAIL PROTECTED]> wrote:
> So the scenario is this. We have two projects starting that will deal
> heavily with mapping spatial regions. One of the reasons I'm looking
> at PostgreSQL is the PostGIS extension that may help us in dealing
> with all the geometry.
>From yo
On 1/22/08, Richard Huxton <[EMAIL PROTECTED]> wrote:
> Alexander Staubo wrote:
> > On 1/22/08, Richard Huxton <[EMAIL PROTECTED]> wrote:
> >> Although the row-estimate still seems quite high. You might want to
> >> increase it even further (maximum is 100
On 1/22/08, Richard Huxton <[EMAIL PROTECTED]> wrote:
> Although the row-estimate still seems quite high. You might want to
> increase it even further (maximum is 1000). If this is a common query,
> I'd look at an index on (user,id) rather than just (user) perhaps.
Actually that index (with the sa
On 1/22/08, Richard Huxton <[EMAIL PROTECTED]> wrote:
> Hmm, but with an estimated cost of 3646 (vs.633 for the max(*) which
> uses the wrong index). That explains why it's walking backwards through
> the pkey index, it thinks that it's 8 times cheaper.
[...]
> Have a look at most_common_vals,most_
On 1/22/08, Richard Huxton <[EMAIL PROTECTED]> wrote:
> Alexander Staubo wrote:
> > # explain analyze select max(id) from user_messages where user_id = 13604;
> >
&g
This is on a fresh pg_restore copy that I have additionally vacuumed
and analyzed. These queries, on a table containing 2.8 million rows,
are very fast:
# select count(*) from user_messages where user_id = 13604;
count
---
0
(1 row)
Time: 0.604 ms
# select * from user_messages where use
On 12/7/07, Josh Harrison <[EMAIL PROTECTED]> wrote:
> I have 2 servers on which I need to have data replicated. The master server
> should serve for read/write queries and the 2nd server is used mainly for
> research queries(read-only queries) and so it doesn't have to be up-to-date.
...
> Is it p
On 11/30/07, Peter Childs <[EMAIL PROTECTED]> wrote:
> Now We used somthing called Ingres at University (I graduated in 2000) but
> I've not heard anything about it since and google does not return anything.
> So we might be talking about different products?
http://en.wikipedia.org/wiki/Ingres
A
On 11/25/07, Glyn Astill <[EMAIL PROTECTED]> wrote:
> So far the only methods I see would be usable for us are Slony I and
> WAL log shipping.
WAL shipping probably does not work the way you think it does. The
secondary server that receives the log pieces is not actually able to
serve any queries;
On 11/15/07, Abraham, Danny <[EMAIL PROTECTED]> wrote:
> In Oracle we erase 50,000 records using the following:
>
> Delete where and ROWNUM < 5;
>
> Do we have such a feature in PG?
Just delete with a subselect:
delete from where in (
select from order by
limit 5);
For examp
On 11/15/07, Abraham, Danny <[EMAIL PROTECTED]> wrote:
> With Oracle we do it with: delete ,tname> where and rownum < Y;
You could create a temporary sequence:
create temporary sequence foo_seq;
delete from foos where nextval('foo_seq') < 5;
I'm not sure how fast nextval() is, even o
[Reposting accidental private response to list]
On 11/15/07, Abraham, Danny <[EMAIL PROTECTED]> wrote:
> How do I add a note to a thread?
You add pgsql-general@postgresql.org to To: or Cc:. Your mail program
probably has a "Reply to all" button that will accomplish this.
> THE problem is that th
On 10/27/07, Bob Pawley <[EMAIL PROTECTED]> wrote:
> I would like to try PostgreSQL 8.3 without uninstalling version 8.1.
>
> Is this possible??
Sure. If you're on Unix, download the source and install it somewhere
in, say, your home directory. This requires a certain familiarity with
the shell, h
On 9/18/07, Merlin Moncure <[EMAIL PROTECTED]> wrote:
> Florian has been hard at work on getting the lazy xid assignment patch
> in for 8.3, which is now complete. AIUI, this is an important step
> towards read only pitr slave (with other advantages too), and shows
> that things are moving along.
On 9/15/07, Marinos Yannikos <[EMAIL PROTECTED]> wrote:
> this might not be the best place to ask, but has there been any further
> progress or an alternative project to Florian Pflug's SoC 2007 proposal
> about enabling PITR slaves to serve read-only queries? It seems like an
> elegant way to load
On 9/13/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> i add more column not row for new user. i want all "last like 'J%'".
> http://www.nabble.com/an-other-provokative-question---tf4394285.html
Sorry, but the only difference between your table example and your
result example was the absence,
On 9/13/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> hello
>
> table is
> +---+---+--+---+
> | id | one | two | three |
> +---+---+--+---+
> | first | Jack | Jill | Mary |
> | last | Ja | Ji | Ma |
> +---+---+--+---+
>
> result is
> +
On 8/24/07, Dave Page <[EMAIL PROTECTED]> wrote:
> Alban Hertroys wrote:
> > So actually the remark shouldn't be that "the multi-threaded
> > architecture is only advantageous on Windows", but more like "the
> > multi-process architecture is disadvantageous on Windows and hence a
> > multi-threade
On 8/15/07, Harpreet Dhaliwal <[EMAIL PROTECTED]> wrote:
> And this feature i.e. transactional DDL is not there in other major RDBMS
> like sql server, oracle etc?
The subject of transactional DDL and its prevalence was discussed in a
May thread, "why postgresql over other RDBMS"
(http://archives.
On 8/4/07, hanasaki <[EMAIL PROTECTED]> wrote:
> clustering failover... ala Oracle Parallel server
Note that OPS is now called RAC (see http://orafaq.com/faq/what_is_rac_ops).
> How can the server be setup in a cluster for load-balancing and failover
> like perhaps OPS?
As I understand it, RAC i
On 8/6/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> the last few years we ran with horizontal partitioning. i always ran into
> problems with horizontal partioning because few tables must be shared across
> the databases and sometimes things are moving and i got lot of trouble with
> my prima
On 7/30/07, mgould <[EMAIL PROTECTED]> wrote:
> I'm in the process of moving to PostGres from iAnywhere's SQL Anywhere v 10.
> One of the neat features from ASA 10 is the ability to create "proxy
> tables" These tables can be local or remote.
Check out the dblink contrib module that comes with P
On 7/12/07, imageguy <[EMAIL PROTECTED]> wrote:
Are there pre-existing tools out there that does this sort of thing ??
Rails and Django -- two popular web development frameworks -- support
a simple mechanism for doing schema migrations.
In Rails, in particular, each schema change is encapsulat
On 7/12/07, Tom Allison <[EMAIL PROTECTED]> wrote:
I tried to install postgres onto my macbook via 'fink' and don't like
it all that much.
I decided to install from source, it's a fallback to my slackware days.
Try MacPorts (http://www.macports.org/), a modern BSD-style ports
system for OS X. T
On 7/10/07, Benoit Mathieu <[EMAIL PROTECTED]> wrote:
I saw postgres offers at least 2 method : bytea column with TOAST, or
large objects API.
From the documentation:
All large objects are placed in a single system table called pg_largeobject.
PostgreSQL also supports a storage system calle
On 7/9/07, Mike <[EMAIL PROTECTED]> wrote:
I am designing my database and I was wondering whether my table row
size effects the performance of querying my table. Please note that my
table is being designed to hold high volume of records and I do not
plan to do (select *) for retrieving them. That
On 7/6/07, David Fetter <[EMAIL PROTECTED]> wrote:
At some point, you're going to realize that Rails is the problem, not
the solution. It's written by people who do not understand what a
shared data store is and reflects problems inherent in its native
database platform: MySQL 3.23.
This is ra
On 6/20/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
Just so there is no confusion. These WILL NOT be in 8.3:
http://developer.postgresql.org/index.php/Todo:PatchStatus
Apologies. I didn't know they had been put on hold.
Alexander.
---(end of broadcast)-
On 6/20/07, Christan Josefsson <[EMAIL PROTECTED]> wrote:
Anyone using these patchese on production systems?
If these are the same patches that were made for Bizgres, then they
are bound to be in use in some current production systems of that
version of PostgreSQL.
If there's any PgSQL develo
On 6/18/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
My database has shutdown several times in the last couple days. I have no
idea why.
[...]
LOG: server process (PID 501) was terminated by signal 9
If this is Linux, check the kernel log (typically /var/log/kern.log,
or run dmesg) and
On 6/17/07, Ron Johnson <[EMAIL PROTECTED]> wrote:
On 06/16/07 17:05, Alexander Staubo wrote:
> On 6/16/07, Ron Johnson <[EMAIL PROTECTED]> wrote:
>> > Hardware acceleration for quickly counting the number of
>> > set/unset/matching bits?
>>
>> x86
On 6/16/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Alexander Staubo" <[EMAIL PROTECTED]> writes:
> On 6/16/07, Tom Allison <[EMAIL PROTECTED]> wrote:
>> It might make an interesting project, but I would be really depressed
>> if I had to go buy an NVid
On 6/16/07, Ron Johnson <[EMAIL PROTECTED]> wrote:
> Hardware acceleration for quickly counting the number of
> set/unset/matching bits?
x86 doesn't already do that?
I don't think so. The fastest way, I believe, is to use precomputed
lookup tables. Same for finding the least/most significant s
On 6/16/07, Tom Allison <[EMAIL PROTECTED]> wrote:
It might make an interesting project, but I would be really depressed
if I had to go buy an NVidia card instead of investing in more RAM to
optimize my performance!
Why does it matter what kind of hardware you can (not "have to") buy
to give
On 6/11/07, Mike Gould <[EMAIL PROTECTED]> wrote:
How can we do this with PostGres? Other than backup and restore or creating
SQL scripts I haven't been able to find another method. Some of these
tables may have over a million rows in them initially if we convert old
data.
The most portable w
On 6/10/07, Tom Allison <[EMAIL PROTECTED]> wrote:
The table itself is small (two columns: bigint, int) but I'm wondering when I'll
start to hit a knee in performance and how I can monitor that.
You don't say anything about what the data is in the table or what
queries you run against it, so th
On 6/8/07, Martijn van Oosterhout <[EMAIL PROTECTED]> wrote:
On Thu, Jun 07, 2007 at 11:20:20AM -0700, Sergei Shelukhin wrote:
> Version is 8.1
> The query I originally ran returned ~4-5 rows and had a lot of other
> joins and filtering conditions prior to the join with the big table.
> Is there
On 6/8/07, Billings, John <[EMAIL PROTECTED]> wrote:
Does anyone think that PostgreSQL could benefit from using the video card
as a parallel computing device? I'm working on a project using Nvidia's
CUDA with an 8800 series video card to handle non-graphical algorithms.
I'm curious if anyone
On 6/8/07, ABHANG RANE <[EMAIL PROTECTED]> wrote:
Hi,
I have a table with one column as real[]. Now if I want to make cubes
out of each of
these arrays, is there a way in postgre I can do it. I guess cube
operator is not defined
for real[] but can I create cubes if the column was integer[]. If ye
On 6/7/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
Joshua D. Drake wrote:
> Hello,
Is anyone going to try for this? If not I can have our designer do it,
but I would prefer it be a community deal.
>
> We are looking to have new signage for the shows that PostgreSQL
> attends. The signage tha
On 6/4/07, Andrew Sullivan <[EMAIL PROTECTED]> wrote:
On Mon, Jun 04, 2007 at 12:37:42AM +0200, PFC wrote:
> NULL usually means "unknown" or "not applicable"
Aaaargh! No, it doesn't. It means NULL. Nothing else.
If it meant unknown or not applicable or anything else, then
SELECT * F
On 6/4/07, Tino Wildenhain <[EMAIL PROTECTED]> wrote:
Did you have a look at BizgresMPP?
Especially for your shared-nothing approach it seems to be a better
solution then just replicating everything.
I had completely forgotten about that one. Bizgres.org seems down at
the moment, but looking a
On 6/4/07, Jeff Davis <[EMAIL PROTECTED]> wrote:
On Sun, 2007-06-03 at 22:54 +0200, Alexander Staubo wrote:
> I agree with you and I don't; as it stands now, it's too hard to
> implement validation in the database alone, for the reasons I stated
> earlier. But I would l
On 6/3/07, Martijn van Oosterhout <[EMAIL PROTECTED]> wrote:
> For example, part of the point of having validations declared on the
> model is so that you can raise user-friendly errors (and pipe them
> through gettext for localization) such as "Your password must be at
> least 4 characters long
On 6/3/07, Ian Harding <[EMAIL PROTECTED]> wrote:
On 6/3/07, Alexander Staubo <[EMAIL PROTECTED]> wrote:
> Your patch is awful because it would mean there was no way to enter an
> empty string in the database. A one-character string containing a
> single space is not an em
On 6/3/07, Ian Harding <[EMAIL PROTECTED]> wrote:
> An empty string is not null! Null means the value is missing, which is
> clearly not the case here. I would say Rails is exactly in the right
> here. When an HTML form is posted, empty input boxes are declared as
> empty strings, which what the
On 6/3/07, Ian Harding <[EMAIL PROTECTED]> wrote:
Rails propaganda explicitly proposes not "repeating yourself" and
[...]
The creator of RoR explicitly discourages use of RI, rules, triggers,
etc in the database as unnecessary. His disciples take this as
gospel.
The creator of Rails is not t
On 6/3/07, Alexander Staubo <[EMAIL PROTECTED]> wrote:
As a side-note, I sat up pgpool-II today, and was pleasantly surprised
about how easy it all was; within two minutes I had two databases in
perfect sync on my laptop. It has limitations (such as in its handling
of sequences), but compa
On 6/3/07, Madison Kelly <[EMAIL PROTECTED]> wrote:
> Slony is indeed intended for near-real-time replication; it's
> asynchronous, so slaves always lag behind the master. The amount of
> discrepancy depends on a bunch of factors -- individual node
> performance, network performance, and system l
On 6/2/07, Jasbinder Singh Bali <[EMAIL PROTECTED]> wrote:
[snip]
I believe that if a database supports transactional ddl then ddl1 and ddl2
would commit together as a batch
And
If a Db doesn't support this transactional DDL feature then ddl1 executes
and commits without even caring about ddl2. R
On 6/2/07, Martijn van Oosterhout <[EMAIL PROTECTED]> wrote:
I don't know if it's a general problem, but I've been involved in a
using rails and it appears to have it's own way of declaring the
database. It presumes to handle referential integrity and uniqueness in
the application code (!).
I t
On 6/1/07, Chris Browne <[EMAIL PROTECTED]> wrote:
There would be *some* scalability gains to be had, but the primary
reason for looking for multimaster replication is that you need high
availability so badly that you are willing to give up performance to
get it.
...dependent on some specific d
On 6/2/07, Guy Rouillier <[EMAIL PROTECTED]> wrote:
Have you looked at raidb? http://c-jdbc.objectweb.org. Narrow niche,
but if it happens to be the one you are in, then it's an option. I took
a quick look at the user's page, and both of them were using PostgreSQL.
Looked at it briefly. C-JD
On 6/1/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
Alexander Staubo wrote:
> You mean aside from the obvious one, scalability?
Multimaster doesn't give you scalability (at least not like a lot of
people think it does).
That depends on your particular definition of multimaste
On 6/1/07, Madison Kelly <[EMAIL PROTECTED]> wrote:
After realizing that 'clustering' in the PgSQL docs means multiple
DBs behind one server, and NOT multple machines, I am back at square
one, feeling somewhat the fool. :P
I remember being similarly disappointed in this rampant co-opting of
On 6/2/07, Jeff Davis <[EMAIL PROTECTED]> wrote:
Here is some work going on that looks like what you want:
http://archives.postgresql.org/pgsql-hackers/2007-03/msg00050.php
I had no idea someone was working on WAL-log-based replication; I saw
the TODO entry a while ago, but I missed the thread
On 6/2/07, Andrew Sullivan <[EMAIL PROTECTED]> wrote:
On Sat, Jun 02, 2007 at 12:05:20AM +0200, Alexander Staubo wrote:
> All you would require is a simple boolean flag to enable or disable
> automatic DDL propagation, surely.
You know, it is just possible that some of the respo
On 6/1/07, Andrew Sullivan <[EMAIL PROTECTED]> wrote:
On Fri, Jun 01, 2007 at 11:08:50PM +0200, Alexander Staubo wrote:
> That doesn't make any sense. As a database *user* it's my prerogative
> to criticize the bits that make my life painful.
Sure. And as a user of fre
On 6/2/07, Gregory Stark <[EMAIL PROTECTED]> wrote:
"Alexander Staubo" <[EMAIL PROTECTED]> writes:
> I would love for the answer to have been "sorry, we did not have time
> or manpower enough to implement fully transparent replication yet,
> because it'
On 6/1/07, Andrew Sullivan <[EMAIL PROTECTED]> wrote:
> I could be wrong, but I believe Slony fails at this because it is
> trigger-based and simply cannot detect DDL changes.
No, there were in fact alternatives (like, for instance, patching the
back end code). But that was undesirable for the
On 6/1/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
As the owner of a company that actually actively developing a
replication system and has for years... I suggest you start putting your
code where your words are.
That doesn't make any sense. As a database *user* it's my prerogative
to critic
On 6/1/07, Jeff Davis <[EMAIL PROTECTED]> wrote:
On Fri, 2007-06-01 at 17:00 +0200, Alexander Staubo wrote:
> the projected Slony-II design, but the setup seems dead simple, and
> from the docs I have found it seems to transparently replicate schema
> changes, unlike Slony-I. So t
On 6/1/07, Andrew Sullivan <[EMAIL PROTECTED]> wrote:
These are all different solutions to different problems, so it's not
surprising that they look different. This was the reason I asked,
"What is the problem you are trying to solve?"
You mean aside from the obvious one, scalability?
The dat
On 6/1/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
> In the meantime, Cybertec (http://www.postgresql.at/, an Austrian
> company) just announced a commercial synchronous multimaster
> replication product based on 2-phase commit. It's expensive, and I
[snip]
I could be completely cranked but
On 6/1/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I'm disappointed because SLONY-II has not been released yet to support
multi-master replication!
I wouldn't pin all my hopes on a project still under development. (For
me, personally, add the fact that Slony-I still has not solved
single-m
One year ago there was a brief discussion about possibly implementing
stats for the number of queries (ie., selects) executed by the server:
http://archives.postgresql.org/pgsql-performance/2006-05/msg00428.php
I was hoping for something akin to the pg_stat_*_tables and its
n_tup_{ins,del,upd}
We're derailing the thread, but...
On 5/24/07, A.M. <[EMAIL PROTECTED]> wrote:
2PC requires that the modifications already be in concrete. What I
suggest is a method for a new connection to insert itself into an
existing (sub-)transaction SQL stream, make changes, and commit to
the root or paren
On 5/24/07, PFC <[EMAIL PROTECTED]> wrote:
Flickr uses InnoDB, by the way.
The master does. The slaves use MyISAM, according to Cal Henderson:
http://www.slideshare.net/coolpics/flickr-44054
Alexander.
---(end of broadcast)---
TIP 6: e
On 5/24/07, Ron Johnson <[EMAIL PROTECTED]> wrote:
> [2] Nobody else has this, I believe, except possibly Ingres and
> NonStop SQL. This means you can do a "begin transaction", then issue
> "create table", "alter table", etc. ad nauseum, and in the mean time
> concurrent transactions will just wo
On 5/24/07, Richard Huxton <[EMAIL PROTECTED]> wrote:
Tom Allison wrote:
> You've addressed cost and performance.
> Not much left.
>
> Try it out for yourself and see if it works for you.
+ elephant in logo
- unpronounceable name
+ excellent mailing lists
+ excellent developer community
- you ca
On 5/23/07, PFC <[EMAIL PROTECTED]> wrote:
+---+---+--+-+
| Table | Op| Msg_type | Msg_text|
+---+---+--+-+
| forum_bench.posts | check | warning |
On 5/23/07, Dann Corbit <[EMAIL PROTECTED]> wrote:
In SQL*Server it is called "UPDATE STATISTICS"
http://msdn2.microsoft.com/en-us/library/ms187348.aspx
No -- MS SQL Server's "update statistics" is the equivalent of
"analyze", not "vacuum."
Alexander.
---(end of broad
On 5/23/07, Harpreet Dhaliwal <[EMAIL PROTECTED]> wrote:
I was wondering if Vacuum DB concept in Postgres is really novel and there's
no concept like this in other RDBMS like oracle or sql server.
If at all other RDBMS have such a concept implemented, how good or bad it is
as compared to postgres
On 5/23/07, Naz Gassiep <[EMAIL PROTECTED]> wrote:
"*Really* big sites don't ever have referential integrity. Or if the few
spots they do (like with financial transactions) it's implemented on the
application level (via, say, optimistic locking), never the database level."
It's not just the big
On 5/14/07, Andrus <[EMAIL PROTECTED]> wrote:
How to create function which returns persons age in years?
[snip]
What's wrong with age()?
# select age('1879-03-14'::date);
age
--
128 years 2 mons
# select extract(year from age('1879-03-14'::date));
date_part
---
On 5/10/07, Jan Strube <[EMAIL PROTECTED]> wrote:
is there a way to invoke a trigger only if the current transaction is
committed?
The problem is that my trigger does some kind of logging outside the
database and therefore must not be invoked if the transaction is rolled
back.
PostgreSQL does n
On 5/3/07, Matthew Hixson <[EMAIL PROTECTED]> wrote:
Is there a significant performance difference between using int
primary keys and string primary keys in Postgres?
PostgreSQL uses B-trees for its indexes, insertion time is logarithmic
regardless of the type of the key, but strings have a
On 5/2/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
We're running Oracle 9 here, and it's even worse than vacuuming. Once a
table grows, it stays grown until you rebuild it (you use the move
command, you just don't move it), and if it's filled up it's tablespace,
It's been a while since I touc
On 5/2/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> They're different pages. The first one is horribly out of date;
> unfortunately, it is (for me) the first hit on Google, whereas the
> PgFoundry project page is the third.
Sure, they are different pages, but the first one is supposed to be
m
On 5/2/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
Alexander Staubo wrote:
> On 5/2/07, Jamie Deppeler <[EMAIL PROTECTED]> wrote:
> >You might want to check pgcluster out
> >http://pgcluster.projects.postgresql.org/ witch does both.
>
> That page will give you
On 5/2/07, Harpreet Dhaliwal <[EMAIL PROTECTED]> wrote:
I'm kind of new to postgresql and the project that I'm working on currently
deals with parsing emails, storing parsed components in postgresql DB and
fire triggers
on certain inserts that opens socket connection with a unix tools server,
A
On 5/2/07, Jamie Deppeler <[EMAIL PROTECTED]> wrote:
You might want to check pgcluster out
http://pgcluster.projects.postgresql.org/ witch does both.
That page will give you the impression that this project is dead and
abandoned -- the last update is from early 2005. PGCluster does seem
to be a
On 5/1/07, Jan Bilek <[EMAIL PROTECTED]> wrote:
Is Slony-I capable of load balancing and how to set it up? We searched the
web and some people mentioned that Slony-I could do load balancing, but
haven't found how to make Slony-I to do it.
Slony does not do load balancing. Personally, I recommen
On 4/28/07, Rich Shepard <[EMAIL PROTECTED]> wrote:
I would like to store a temporal frequency as NUMERIC, without units, and
have the application's front end (or middleware) transform the number to the
appropriate interval name. I'm having difficulties figuring out how to do
this.
This is a
On 4/29/07, Rich Shepard <[EMAIL PROTECTED]> wrote:
Thank you. I never before was aware of DRI, but Joe Celko mentions it
several times in his book, "SQL Programming Style." I searched with Google
and found a couple of hits that were postgres specific so I went looking in
the docs to learn wha
On 4/29/07, Rich Shepard <[EMAIL PROTECTED]> wrote:
I cannot find a discussion of the meaning and use of Declarative
Referential Integrity (DRI) in the on-line docs ToC or Index. Please tell me
in which chapter/section this is covered.
The closest counterpart to MS SQL Server's DRI is the "r
On 4/28/07, Rich Shepard <[EMAIL PROTECTED]> wrote:
I would like to store a temporal frequency as NUMERIC, without units, and
have the application's front end (or middleware) transform the number to the
appropriate interval name. I'm having difficulties figuring out how to do
this.
This is a
On 4/27/07, Steve Crawford <[EMAIL PROTECTED]> wrote:
Anyone have any ideas on how to handle a work queue? I've been thinking
about optimizing this process for quite a while.
I have been using PostgreSQL for the exact same thing, except I have
not yet reached the stage where I need to process q
On 4/24/07, Mageshwaran <[EMAIL PROTECTED]> wrote:
I want to do replication using WAL , please tell the methods by which
log shipping is done ie moving the wal files to slaves and executing it.
Not possible at the moment: the log shipping facility that was
introduced in 8.2 only lets you set up
On Apr 9, 2007, at 18:10 , Gerard Seibert wrote:
On Mon, 9 Apr 2007 10:34:22 -0500
Erik Jones <[EMAIL PROTECTED]> wrote:
Hmmm... I didn't have anything HTML set anywhere. I did however
have message formatting set to Rich-Text (although I was unaware)
and have switched that to plaintext. Thi
On Mar 31, 2007, at 12:19, Ron wrote:
Subject says it all. Doing a source compile under Debian or Debian-
like condition is not an option for the end user. They need an apt-
get (the ubuntu equivalent to rpm AFAICT) version.
Ubuntu has 8.2.3 in the upcoming Feisty distribution; in the
mea
On Feb 2, 2007, at 04:48 , Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/01/07 21:31, RPK wrote:
How is FireBird rated when compared with PostgreSQL?
Rated?
Clearly, Firebird is a 2.0 and PostgreSQL is an easy 8.2.
Alexander.
---(end of b
On Dec 5, 2006, at 21:56 , Wei Weng wrote:
I have a table that has roughly 200,000 entries and many columns.
The query is very simple:
SELECT Field1, Field2, Field3... FieldN FROM TargetTable;
This is the very definition of a sequential scan: you're reading
200,000 rows from that table, an
On Nov 27, 2006, at 18:13 , Andrus wrote:
I need to create nightly backups to separate computer over internet
from 8.1
server
I tried to run pg_dump to make backup using command
"..\pg_dump\pg_dump.exe" -i -Z9 -b -v -f "C:\061127
mybackup.backup" -F c -h
81.50.12.18 -U myuser -p 5431 mydb
On Nov 27, 2006, at 02:45 , Tom Lane wrote:
Alexander Staubo <[EMAIL PROTECTED]> writes:
select comments.*, users.*
from comments
left outer join users on
users.id = comments.creator_id
inner join events_comments on
comments.id = events_comments.comment_id
and events_comments.ev
I have thee primary tables: comments, events and users. There's a
join table events_comments tying comments to events. There are B-tree
indexes on every column involved, and the tables are freshly vacuumed
and analyzed;
A simple select to retrieve all comments for a given event, with an
o
On Nov 24, 2006, at 01:37 , Jerry Sievers wrote:
Have a look at the query_start field in pg_stat_activity for the
process holding locks that's causing backlog.
Doesn't this require "stats_command_string = on"? I don't have that
enabled on production servers.
Alexander.
---
1 - 100 of 133 matches
Mail list logo
