On Tue, Feb 24, 2004 at 10:40:30AM -0800, jake johnson wrote:
> I'm running PG 7.4.1 on FreeBSD 5.2.1_RC1 and experienced a general
> 40% drop in performance after increasing Shared mem buffers to 2000
> (from the 1000 default setting) and the Sort Mem to 1024 from 16.
> After changing the .conf f
On Wed, Feb 25, 2004 at 02:10:56PM -0700, Rick Gigger wrote:
> I want to know how much memory I've got free on my system.
>
> The free command gives me something like this:
>
> total used free sharedbuffers cached
> Mem: 20648322046196 18636
"Karam Chand" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
> 5.) In MySQL, there are many command like show tables,
> show databases etc. to get object details. I cant see
> anything similar in PGSQL. After searching the net i
> find that i have to execute certain queries to fetch
>>Is there a shorthand notation when performing a multi-table join and
What's the difference between a "multi-table join" and a "join"?
>> one column is to be equaled in all tables?
>
> Is this you are looking for?
>
> SELECT t1.c7,t2.c6
> FROM t1,t2
> USING (c1,c2,c3)
> WHERE t1.c4='2004-2-28'
I'm designing a fairly involved database system. As part fo the process, I
use the \i [FILE] command a great deal. I set up fairly involved queries,
sometimes simply for the purpose of shortening column names so the output
is reasonable. For example:
SELECT longname AS abbr,othername as "V" FROM t
MaRCeLO PeReiRA wrote:
> Hi guys,
>
> Please, give me some advices on how to do the
> following:
>
> I have the following table:
>
> CREATE TABLE products (
>idSERIAL,
>description TEXT,
>lastupdatedate
> );
>
> Well, I would like to update the column "lastupdate"
I recently installed 7.4.1 on two different machines (Linux/Intel and MacOSX)
and in both cases the commands in src/backend/command did not get installed.
Everything else is okay, as far as I can tell. I tried re-running make install
on both machines and still, nothing. I have had 7.3.x fully insta
I'm using postgresl 7.3.2 and have a query that executes very slowly.
There are 2 tables: Item and LogEvent. ItemID (an int4) is the primary key
of Item, and is also a field in LogEvent. Some ItemIDs in LogEvent do not
correspond to ItemIDs in Item, and periodically we need to purge the
non-mat
Hello all!
when asking postgres to aggregate totals accross 4.5 or so Million records.
The visible effect is that the postmaster will grow to the 3GB process limit and die
without a core :(.
I have seen this same behaviour discussed back in 6.5 archives in the thread with subject "[SQL]
Erwin Van de Velde wrote:
> Hi,
>
> I have to copy data from one table to another, and I was wondering if
> there is an easier way to do that than to have a lot of inserts one after
> another.
insert into target_table select * from source-table where ...;
Björn Lundin
[EMAIL PROTECTED] (Sean Shanny) writes:
> Can you give an example of a query that has gotten slower due to the
> increasing size of the urls table with an explain analyze?
There's a "known issue" in that URL strings commonly contain the prefix:
http://www.
What you get, as a result, is that t
Hi,
I finished the installation of the postgresql-7.4.1 with the Red Hat Linux
V9.0
by using the user account pgsql.
But I can not create the sa account and can not create database ?
Help^^^
---(end of broadcast)---
TIP 8: explain analyze i
Hi list,
Does anybody use pgCluster in production environment?
Actually I look for any reliable way for PostgreSQL replication, preferable
multi-master, but single-master would be OK at the moment. Maybe there are
other packages enabling replication?
Thanks,
Mike.
---(
Den Fri, 20 Feb 2004 23:55:33 -0500. skrev Tom Lane:
> It sounds like you have a badly corrupted database :-(. However, the
> pg_dump message is of little help in delving further than that. What
> shows up in the postmaster log? If the backend is dumping core, can
> you get a stack trace?
The
Is there an option for psql to use the entry in Comments for "pretty"
column headings in a report? For example, instead of printing the
column name of "last" in the heading, the option would print "Last
Name" that is contained in the Comments field.
The only two alternatives I've found so far
Hello!
I recently tried the open source forum software phpBB the CVS version,
2.1/2.2. To my surprise, I've found that it's lacking PostgreSQL
support, or, rather, that its support is not functional.
After playing around for a bit, I managed to get a semi-functional
2version working, I went and h
Thanks Greg.
That does help me some, however, I am stuck with this database (I have
inherited) - it has over a hundred tables, and while I may look into
converting it at some point, it is just unfeasible at this junction. So
where can I look to find the hard way? :)
HG
"Greg Patnude" <[EMAIL PR
Hi,
I'm implementing a database with very 'restrictive'
privileges. However I've hit a dead end trying to
solve one issue.
When GRANTing execute to a plpgsql function it
appears to run with the priviledge of the user and
NOT with the priviledges of the owner of the function.
This is causing a p
Oh, the rerun of the pg_dump was a little different after the typnamespace
cleanup, but still failed..
pg_dump -v mydb | more
pg_dump: saving database definition
pg_dump: reading namespaces
pg_dump: reading user-defined types
pg_dump: reading user-defined functions
pg_dump: reading user-defined ag
In PGAdmin III -- you might want to UNCHECK the "Display system objects"
option under the "Display" menu option -- this will prevent you from seeing
all of the non-public schema's and limit your view in PGAdmin to just the
databases you created...
Most people dont really need to dink around with t
I'm running PG 7.4.1 on FreeBSD 5.2.1_RC1 and experienced a general
40% drop in performance after increasing Shared mem buffers to 2000
(from the 1000 default setting) and the Sort Mem to 1024 from 16.
After changing the .conf file back to the original values, performance
didn't change back. Only
Hi,
I have table:
# \d category;
category_id | integer| not null default
nextval('public.category_category_id_seq'::text)
category_name | character varying(100) | not null
Indexes: category_pkey primary key btree (category_id)
My goal is to remove sequence from category_id
I want to know how much memory I've got free on my system.
The free command gives me something like this:
total used free sharedbuffers cached
Mem: 20648322046196 18636 0 1468921736968
-/+ buffers/cache: 1623361902496
Sw
Hi
I am using the standard debian testing release of postgres(7.3.4)
and was wondering how to produce and md5 string.
I had thought
Select md5(‘joe’);
Would be sufficient?
Any ideas, or is the best option to create a perl function
to do this for me ?
Simon
Simon
Hi all. Quick and perhaps silly question, but...
I am using Pg 7.3. I am writing a function using pgplsql. This function will
perform multiple inserts. Let's say two of the inserts are as follows:
-- id is primary key
insert into users (id, username) values (nextval('someSeq'),'somename');
-- id
That's the hard way
You'd be better off redefining your table structures so that postgreSQL
handles the primary keys automatically...
CREATE TABLE test (
id integer primary key not null default nextval('test_seq'),
log varchar(32) NOT NULL,
message text
) WITH OIDS;
Using this
I don't think so --- we weren't trying to use it as an actual column
datatype back then.
7.4 has a problem though :-( ... this is one of the "damn I wish we'd
caught that before release" ones, since it can't easily be fixed without
initdb. Reminds me that I need to get to work on making pg_upgrade
Hi,
I don't suppose that the todo item:
Referential Integrity
o Add deferred trigger queue file (Jan)
Means that there will be a statement like:
CREATE TRIGGER ... FOR EACH TRANSACTION
?
I frequently encounter situations where the
database is only 'good' when all the the statements
in the tr
Thank you for the idea Tom.
I tried it, and it didn't fix it (there are now no rows with
typnamespace=2200, the pg_dump fails with the same debug information
as before.
I am running 7.3.2 and never migrated from an earlier version, so
maybe this bug isn't completely licked yet in this version? No
Are others having problems with gborg this afternoon?
A
--
Andrew Sullivan
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
As it turns out, LEFT OUTER JOIN does exactly what I want.
I'm not sure what my original problem was now, though I suspect it was
part of the "where" clause depending on the right side of the join.
So for anyone who might find this thread in a search for this kind of
behaviour, just use LEFT OUTE
Thank for the reply.
I will move this onto the perfromance group, except that for some odd reason I cant
see a
performance group on usenet. I will subscribe to the mailing list
I will gladly upload the schema (script) or anything else that anyone wants, but it
may not be
appropriate for a n
32 matches
Mail list logo
