Dear Everybody!
I want to ask that have some way to install PGSQL 9.0 as two instances
in one machine?
Most important question. The OS is can be Windows or Linux.
I asked this, because formerly we heard about a story. I cite this as I
remember:
We have some product, and in the only
On 14/04/11 23:25, Vick Khera wrote:
On Thu, Apr 14, 2011 at 12:19 AM, Benjamin Smith
li...@benjamindsmith.com mailto:li...@benjamindsmith.com wrote:
I was wondering if anybody here could comment on the benefits of SSD
in similar, high-demand rich schema situations?
For the last
2011/4/20 durumdara durumd...@gmail.com:
Dear Everybody!
I want to ask that have some way to install PGSQL 9.0 as two instances in
one machine?
Most important question. The OS is can be Windows or Linux.
I asked this, because formerly we heard about a story. I cite this as I
remember:
On Wed, Apr 20, 2011 at 12:13 AM, Andrej andrej.gro...@gmail.com wrote:
That's an accurate observation, but has nothing to do w/ what
the original poster was looking for, nor does it refute Toms
argument against the OPs suggestion.
You're right, I jumped in without thinking enough.Sorry.
I
On a fast network it should only take a few minutes. Now rsyncing
live 2.4 TB databases, that takes time. :) Your raptors, if they're
working properly, should be able to transfer at around 80 to
100Megabytes a second. 10 to 15 seconds a gig. 30 minutes or so via
gig ethernet. I'd run
On 2011-04-06, Carlos Mennens carlos.menn...@gmail.com wrote:
I've only been using PostgreSQL since Oct 2010 and it's my first
experience with SQL or any ORDBMS. I've searched on the web and been
creating my own database users, databases, tables from scratch which
has been interesting to say
On 2011-04-06, Jerry Sievers gsiever...@comcast.net wrote:
Carlos Mennens carlos.menn...@gmail.com writes:
CREATE TABLE users
(
id integer PRIMARY KEY UNIQUE NOT NULL, --ID
fname character varying(40) NOT NULL, --First name
lname character varying(40) NOT NULL, --Last name
In response to Jasen Betts ja...@xnet.co.nz:
On 2011-04-06, Jerry Sievers gsiever...@comcast.net wrote:
Carlos Mennens carlos.menn...@gmail.com writes:
CREATE TABLE users
(
id integer PRIMARY KEY UNIQUE NOT NULL, --ID
fname character varying(40) NOT NULL, --First name
Hi there
I installed PostgreSql 8.4 and now I want to delete/ uninstall it
completely to start a new fresh installation.
Can you please give me clear instructions on how to do that or maybe a
script that I can run.
I am doing assignment using postgres your help would be highly appreciated.
Mlo
On Wed, Apr 20, 2011 at 12:32 PM, Mlondolozi Ncapayi mlon...@gmail.comwrote:
Hi there
I installed PostgreSql 8.4 and now I want to delete/ uninstall it
completely to start a new fresh installation.
Can you please give me clear instructions on how to do that or maybe a
script that I can
Hello,
I'm executing this query:
SELECT x, y, another_field FROM generate_series(1, 10) x,
generate_series(1, 10) y, my_table
The field 'another_field' belongs to 'my_table'. And that table has
36 entries. In a 64 bits machine, with 4GB RAM, Ubuntu 10.10 and
postgres 8.4.7, the query works
=?ISO-8859-1?Q?Jorge_Ar=E9valo?= jorge.arev...@deimos-space.com writes:
I'm executing this query:
SELECT x, y, another_field FROM generate_series(1, 10) x,
generate_series(1, 10) y, my_table
The field 'another_field' belongs to 'my_table'. And that table has
36 entries. In a 64 bits
Hello,
I'm executing this query:
SELECT x, y, another_field FROM generate_series(1, 10) x,
generate_series(1, 10) y, my_table
Well, do you realize this is a cartesian product that gives
10 x 10 x 36 = 36.000.000
rows in the end. Not sure how wide is the third table (how many columns
Hello,
ROW_NUMBER() is only ready in 8.4. For 8.3, is there a simple way to get
row_number
select row_number(), col1, col2...
FROM tableName
Thanks a lot!
丁叶
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Wed, Apr 20, 2011 at 5:34 PM, Tom Lane t...@sss.pgh.pa.us wrote:
=?ISO-8859-1?Q?Jorge_Ar=E9valo?= jorge.arev...@deimos-space.com writes:
I'm executing this query:
SELECT x, y, another_field FROM generate_series(1, 10) x,
generate_series(1, 10) y, my_table
The field 'another_field'
On Wed, Apr 20, 2011 at 8:39 PM, Mlondolozi Ncapayi mlon...@gmail.comwrote:
Thank Sir, I have managed to uninstall it.
Now I installed PostgreSQL 8.4.4 and PostGIS 1.4.2.
Can you please send me command prompts to load shapefiles using Windows 7.
I want to load cities.shp into
On Wed, Apr 20, 2011 at 9:21 PM, Emi Lu em...@encs.concordia.ca wrote:
Hello,
ROW_NUMBER() is only ready in 8.4. For 8.3, is there a simple way to get
row_number
select row_number(), col1, col2...
FROM tableName
Below link will demonstrates ROW_NUMBER features in pre Postgresql-8.4::
2011/4/20 t...@fuzzy.cz:
Hello,
I'm executing this query:
SELECT x, y, another_field FROM generate_series(1, 10) x,
generate_series(1, 10) y, my_table
Well, do you realize this is a cartesian product that gives
10 x 10 x 36 = 36.000.000
rows in the end. Not sure how wide is the
Hello,
I'm having difficulty pre-loading Perl modules and my own libraries. When I
edit something like this into the postgresql.conf:
custom_variable_classes = 'plperl'
plperl.on_init = 'use MyModule;'
and restart the server it doesn't seem to load the modules (they don't
appear in
Hi
This is probably going to turn out to be me doing something stupid, but-
I have two computers, one of which I use as a remote server for my database.
When I connect to the remote database through my interface there are errors
that suggest a problem with the data in one of the tables.
Frank van Vugt ftm.van.v...@foxi.nl writes:
mmm, indeed it seems that some things are our of sync here
...
This confirms that these 60 functions do not have a 'o' (owner) record in
pg_shdepend, it therefor matches what you seemed to expect: no records in
pg_shdepend, so reassign owned does
By doing \timing in psql, we enable the timing and then when we type the
query we are able to see its execution time.
Similarly, is there any way to view the number I/Os and memory usage by a
particular query.
And also the timing result that gets displayed, in which log file does it
get recorded?
Dne 20.4.2011 12:56, Phoenix Kiula napsal(a):
On a fast network it should only take a few minutes. Now rsyncing
live 2.4 TB databases, that takes time. :) Your raptors, if they're
working properly, should be able to transfer at around 80 to
100Megabytes a second. 10 to 15 seconds a gig. 30
On Wed, Apr 20, 2011 at 10:41 PM, SUBHAM ROY subham@gmail.com wrote:
By doing \timing in psql, we enable the timing and then when we type the
query we are able to see its execution time.
Similarly, is there any way to view the number I/Os and memory usage by a
particular query.
PGsnap
Hi,
Op woensdag 20 april 2011, schreef Tom Lane:
I wonder whether the pg_shdepend data is actually wrong, or just the
indexes on it are at fault. Did you try forcing that query to be done
with a seqscan
Just did by setting enable_indexscan to false and verifying that all is used
are
Frank van Vugt ftm.van.v...@foxi.nl writes:
Op woensdag 20 april 2011, schreef Tom Lane:
To explain your problem that way would require assuming that somebody
was REINDEX'ing pg_shdepend at approximately the same time that somebody
else was rolling back DDL that had modified these same
Hi,
Op woensdag 20 april 2011, schreef Tom Lane:
Actually, now that I think about it, 8.4 didn't allow on-the-fly
reindexing of shared catalogs anyway. So that couldn't be your problem
even if the test had shown the indexes didn't match the catalog. But
it seems the rows actually
Frank van Vugt ftm.van.v...@foxi.nl writes:
Op woensdag 20 april 2011, schreef Tom Lane:
Actually, now that I think about it, 8.4 didn't allow on-the-fly
reindexing of shared catalogs anyway. So that couldn't be your problem
even if the test had shown the indexes didn't match the catalog.
On Wednesday, April 20, 2011 11:09:59 am Bob Pawley wrote:
Hi
This is probably going to turn out to be me doing something stupid, but-
I have two computers, one of which I use as a remote server for my
database.
When I connect to the remote database through my interface there are errors
Dne 20.4.2011 22:11, Tomas Vondra napsal(a):
There's a very nice guide on how to do that
http://blog.endpoint.com/2010/06/tracking-down-database-corruption-with.html
It sure seems like the problem you have (invalid alloc request etc.).
The really annoying part is locating the block, as you
On Tue, Apr 19, 2011 at 9:48 AM, Jens Wilke j...@wilke.org wrote:
On Tue, Apr 19, 2011 at 04:02:01AM +0530, Vibhor Kumar wrote:
IIRC vacuum full mode rewrites the indexes as well.
Till 8.4 no. From 9.0 onwards yes. However VACUUM FULL still locks the
table.
Don't be confused with the
On Wed, Apr 20, 2011 at 1:09 PM, Bob Pawley rjpaw...@shaw.ca wrote:
Hi
This is probably going to turn out to be me doing something stupid, but-
I have two computers, one of which I use as a remote server for my database.
When I connect to the remote database through my interface there are
On Thu, Apr 21, 2011 at 7:27 AM, Tomas Vondra t...@fuzzy.cz wrote:
Dne 20.4.2011 22:11, Tomas Vondra napsal(a):
There's a very nice guide on how to do that
http://blog.endpoint.com/2010/06/tracking-down-database-corruption-with.html
It sure seems like the problem you have (invalid alloc
On Thu, Apr 21, 2011 at 11:49 AM, Phoenix Kiula phoenix.ki...@gmail.com wrote:
On Thu, Apr 21, 2011 at 7:27 AM, Tomas Vondra t...@fuzzy.cz wrote:
Dne 20.4.2011 22:11, Tomas Vondra napsal(a):
There's a very nice guide on how to do that
34 matches
Mail list logo