I have OS X tiger with all the updates:
uname -r
8.8.0
Here is what I get when I try to initdb on a freshly compiled 8.2:
selecting default max_connections ... 10
selecting default shared_buffers/max_fsm_pages ... 400kB/2
creating configuration files ... ok
creating template1 database in /us
Maybe U can't get the disk usage info, but you can try command "explain"
-邮件原件-
发件人: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 代表 JM
发送时间: 2006年12月28日 10:43 MARK
收件人: pgsql-general@postgresql.org
抄送: Pgsql-Performance (E-mail)
主题: [GENERAL] Need Help
how can i get the disk usage for ea
--- JM <[EMAIL PROTECTED]> wrote:
> how can i get the disk usage for each table? can i do it via SQL?
This function should do what you want:
pg_relation_size(text) or pg_total_relation_size(text)
I found it on the following link:
http://www.postgresql.org/docs/8.2/interactive/functions-admi
how can i get the disk usage for each table? can i do it via SQL?
Thanks,
Mailing-Lists
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
Does anyone have libnss_pgsql working on RedHat EL 4.x?
I compiled it ok, but it does not seem to work. I copied the compiled
libs to /lib and setup all the conf files,
but I keep getting a error when I try to logon that states "Cannot
connect to database"
I am running pg 8.1.5(installed via
> Having a mechanism that requires enormous DBA effort and where there
> is considerable risk of simple configuration errors that will be hard
> to notice may not be the best kind of "feature" :-).
Why not? It seems to have worked remarkably well for the market leader ;-)
--
Scott Ribe
[EMAIL PR
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 12/27/06 11:59, Richard Broersma Jr wrote:
>> I'm looking for a database system for a SCADA system. The major
>> probles I think it's on performance because the application
>> it's going to poll about 4k variables per second from hardware
>> and ha
Creating shell scripts and cron jobs are pretty easy tasks in *nix. I wanted
to attach a sample
BAT file script for anyone that is enterested in get something similar to work
under windows.
Comments are welcome.
Copy this text below into you own bat file and then create a
new "scheduled job"
On Wed, 2006-12-27 at 18:13 +, Tomi N/A wrote:
> 2006/12/27, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
> > Hi everybody,
> > I'm looking for a database system for a SCADA system. The major
> > probles I think it's on performance because the application it's going
> > to poll about 4k variables per
2006/12/27, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
Hi everybody,
I'm looking for a database system for a SCADA system. The major
probles I think it's on performance because the application it's going
to poll about 4k variables per second from hardware and has to register
the values on the procces
> I'm looking for a database system for a SCADA system. The major
> probles I think it's on performance because the application it's going
> to poll about 4k variables per second from hardware and has to
> register
> the values on the procces table.
> I heard that PostgreSQL provides a bulk loadin
[EMAIL PROTECTED] writes:
> I was referring to the situation where one has this in a WHERE clause:
>((vConstant IS NULL) OR (Table.IndexedCol = vConstant))
> where vConstant is a *constant* parameter in a pl/pgsql function.
My mistake, I was thinking of Table.IndexedCol IS NULL.
> In the late
On mið, 2006-12-27 at 11:02 -0600, [EMAIL PROTECTED] wrote:
>
> I was referring to the situation where one has this in a WHERE clause:
>
>((vConstant IS NULL) OR (Table.IndexedCol = vConstant))
>
> where vConstant is a *constant* parameter in a pl/pgsql function.
Reguardless of the issue wh
am Wed, dem 27.12.2006, um 13:41:24 -0300 mailte [EMAIL PROTECTED] folgendes:
> Hi everybody,
> I'm looking for a database system for a SCADA system. The major
I don't know, what is a 'SCADA' System?
> I heard that PostgreSQL provides a bulk loading mechanism called COPY,
> which takes tab-de
Tom Lane wrote:
[EMAIL PROTECTED] writes:
I would submit that in that situation, it would be
reasonable for a user to expect my suggested syntax to still use the
indicated indexes.
The only thing that will make that work is if "indexed_col IS NULL" were
an indexable condition, which it isn't
Hi everybody,
I'm looking for a database system for a SCADA system. The major
probles I think it's on performance because the application it's going
to poll about 4k variables per second from hardware and has to
register
the values on the procces table.
I heard that PostgreSQL provides a bulk load
Hi everybody,
I'm looking for a database system for a SCADA system. The major
probles I think it's on performance because the application it's going
to poll about 4k variables per second from hardware and has to register
the values on the procces table.
I heard that PostgreSQL provides a bulk lo
[EMAIL PROTECTED] wrote:
>The question is *why* you feel you need that, ie what are you using
>these for? As was already mentioned upthread, it's usually better
>to avoid explicit locking altogether, if you can.
Scenario 1. One has objects belong to a metaclass. Certain operations changes
metacl
I solved my specific problem by converting the array to a python as follows:
objlist=arr_text[1:-1].replace('"','').split(",")
This removes the quotes in any element that had it already, and then makes a list out of the string
separated by commas.
I'm still curious if it is possible to put the qu
> We are using PostgreSQL 7.3 version, installed in linux
> system. Only DB is getting shut down 3-4 times a day. From my
> application end I get "Sorry too many clients" error.
> Refering the FAQ I maximized the DB session limit to 200.
>
> I think the logs are not enabled in my DB. So I set
20 matches
Mail list logo
