pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
SURVEY: who is running postgresql on 8 or more CPUs?
  2005-05-31 13:16 UTC  Dirk Lutzebäck <lutzeb@aeccom.com>
` Re: SURVEY: who is running postgresql on 8 or more CPUs?
  2005-06-02 08:28 UTC  Dirk Lutzebäck <lutzeb@aeccom.com>
` Re: SURVEY: who is running postgresql on 8 or more CPUs?
  2005-06-02 12:12 UTC  Dawid Kuroczko <qnex42@gmail.com>
` Re: SURVEY: who is running postgresql on 8 or more CPUs?
  2005-06-02 12:28 UTC  Dirk Lutzebäck <lutzeb@aeccom.com>
` Re: SURVEY: who is running postgresql on 8 or more CPUs?
  2005-06-02 15:57 UTC  ohp@pyrenet.fr
  [5+ messages in thread]

Specific query performance problem help requested - postgresql 7.4
  2005-05-26 15:36 UTC  Brad Might <bmight@storediq.com>
` Specific query performance problem help requested - postgresql 7.4
  2005-05-26 17:55 UTC  Brad Might <bmight@storediq.com>
` Re: Specific query performance problem help requested - postgresql 7.4
  2005-05-26 18:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Specific query performance problem help requested - postgresql 7.4
  2005-05-26 18:41 UTC  Brad Might <bmight@storediq.com>
` Re: Specific query performance problem help requested - postgresql 7.4
  2005-06-02 15:03 UTC  Brad Might <bmight@storediq.com>
  [5+ messages in thread]

Moving pg_xlog
  2005-06-01 15:31 UTC  Keith Worthington <keithw@narrowpathinc.com>
` Re: Moving pg_xlog
  2005-06-01 16:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Moving pg_xlog
  2005-06-01 20:11 UTC  Keith Worthington <keithw@narrowpathinc.com>
` Re: Moving pg_xlog
  2005-06-01 20:30 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Moving pg_xlog
  2005-06-01 20:31 UTC  Brad Nicholson <bnichols@ca.afilias.info>
` Re: Moving pg_xlog
  2005-06-01 21:27 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Moving pg_xlog
  2005-06-02 06:06 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Moving pg_xlog
  2005-06-02 07:02 UTC  Himanshu Baweja <himanshubaweja@yahoo.com>
` Re: Moving pg_xlog
  2005-06-02 14:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Moving pg_xlog
  2005-06-02 14:47 UTC  Himanshu Baweja <himanshubaweja@yahoo.com>
  [10+ messages in thread]

postgresql-8.0.1 performance tuning
  2005-05-27 13:41 UTC  Martin Fandel <martin.fandel@alphyra-evs.de>
` Re: postgresql-8.0.1 performance tuning
  2005-05-31 18:46 UTC  John A Meinel <john@arbash-meinel.com>
` Re: postgresql-8.0.1 performance tuning
  2005-06-01 05:30 UTC  Cosimo Streppone <cosimo@streppone.it>
` Re: postgresql-8.0.1 performance tuning
  2005-06-01 06:33 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: postgresql-8.0.1 performance tuning
  2005-06-01 06:44 UTC  Cosimo Streppone <cosimo@streppone.it>
` Re: postgresql-8.0.1 performance tuning
  2005-06-01 07:22 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: postgresql-8.0.1 performance tuning
  2005-06-01 08:50 UTC  Martin Fandel <martin.fandel@alphyra-evs.de>
` Re: postgresql-8.0.1 performance tuning
  2005-06-01 09:57 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: postgresql-8.0.1 performance tuning
  2005-06-01 10:22 UTC  Cosimo Streppone <cosimo@streppone.it>
` Re: postgresql-8.0.1 performance tuning
  2005-06-01 10:26 UTC  Martin Fandel <martin.fandel@alphyra-evs.de>
` Re: postgresql-8.0.1 performance tuning
  2005-06-02 12:50 UTC  Martin Fandel <martin.fandel@alphyra-evs.de>
` Re: postgresql-8.0.1 performance tuning
  2005-06-02 13:10 UTC  Martin Fandel <martin.fandel@alphyra-evs.de>
` Re: postgresql-8.0.1 performance tuning
  2005-06-02 13:12 UTC  Martin Fandel <martin.fandel@alphyra-evs.de>
  [13+ messages in thread]

'Fastest' PC's are slowest in the house
  2005-05-31 17:02 UTC  Justin Davis <justin.davis@rapidsys.net>
` Re: 'Fastest' PC's are slowest in the house
  2005-06-02 06:32 UTC  Grega Bremec <gregab@p0f.net>
  [2+ messages in thread]

TIP 9: the planner will ignore... & datatypes
  2005-06-01 09:45 UTC  Marc Mamin <m.mamin@gmx.net>
` Re: TIP 9: the planner will ignore... & datatypes
  2005-06-01 13:40 UTC  Alvaro Herrera <alvherre@surnet.cl>
  [2+ messages in thread]

slow queries, possibly disk io
  2005-05-26 20:24 UTC  Josh Close <narshe@gmail.com>
` Re: slow queries, possibly disk io
  2005-05-26 21:14 UTC  John Arbash Meinel <john@arbash-meinel.com>
` Re: slow queries, possibly disk io
  2005-05-26 21:23 UTC  Dawid Kuroczko <qnex42@gmail.com>
` Re: slow queries, possibly disk io
  2005-05-27 01:29 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: slow queries, possibly disk io
  2005-05-27 12:52 UTC  Josh Close <narshe@gmail.com>
` slow queries, possibly disk io
  2005-05-27 13:04 UTC  Josh Close <narshe@gmail.com>
` Re: slow queries, possibly disk io
  2005-05-27 13:05 UTC  Josh Close <narshe@gmail.com>
` Re: slow queries, possibly disk io
  2005-05-27 14:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: slow queries, possibly disk io
  2005-05-27 14:54 UTC  Josh Close <narshe@gmail.com>
` Re: slow queries, possibly disk io
  2005-05-27 15:00 UTC  Josh Close <narshe@gmail.com>
` Re: slow queries, possibly disk io
  2005-05-30 22:16 UTC  Rudi Starcevic <tech@wildcash.com>
` Re: slow queries, possibly disk io
  2005-05-31 13:17 UTC  Josh Close <narshe@gmail.com>
` Re: slow queries, possibly disk io
  2005-05-31 14:33 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: slow queries, possibly disk io
  2005-05-31 16:36 UTC  Josh Close <narshe@gmail.com>
` Re: slow queries, possibly disk io
  2005-05-31 18:18 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: slow queries, possibly disk io
  2005-06-01 09:06 UTC  Simon Riggs <simon@2ndquadrant.com>
  [16+ messages in thread]

very large table
  2005-05-31 09:37 UTC  Praveen Raja <praveen.raja@netlight.se>
` Re: very large table
  2005-05-31 14:06 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: very large table
  2005-06-01 08:57 UTC  Simon Riggs <simon@2ndquadrant.com>
  [3+ messages in thread]

Index on a NULL-value
  2005-05-31 03:02 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Index on a NULL-value
  2005-05-31 03:16 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Index on a NULL-value
  2005-05-31 03:21 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Index on a NULL-value
  2005-05-31 03:31 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Index on a NULL-value
  2005-05-31 03:36 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Index on a NULL-value
  2005-05-31 03:45 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Index on a NULL-value
  2005-05-31 04:08 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Index on a NULL-value
  2005-05-31 04:18 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index on a NULL-value
  2005-05-31 04:21 UTC  Greg Stark <gsstark@mit.edu>
` Re: Index on a NULL-value
  2005-05-31 05:12 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index on a NULL-value
  2005-05-31 05:59 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Index on a NULL-value
  2005-06-01 05:42 UTC  Tobias Brox <tobias@nordicbet.com>
  [12+ messages in thread]

Major flood of mail to lists ...
  2005-05-31 17:45 UTC  Marc G. Fournier <scrappy@postgresql.org>

poor performance involving a small table
  2005-05-26 14:57 UTC  Colton A Smith <smith@cs.utk.edu>
` Re: poor performance involving a small table
  2005-05-30 22:00 UTC  Bricklen Anderson <BAnderson@PresiNET.com>
` Re: poor performance involving a small table
  2005-05-31 01:52 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: poor performance involving a small table
  2005-05-31 02:31 UTC  andrew@pillette.com
  [4+ messages in thread]

Drop / create indexes and vacuumdb
  2005-05-30 22:06 UTC  Yves Vindevogel <yves.vindevogel@implements.be>

Postgresql and xeon.
  2005-05-30 13:43 UTC  Eric Lauzon <eric.lauzon@abovesecurity.com>
` Re: Postgresql and xeon.
  2005-05-30 16:19 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Postgresql and xeon.
  2005-05-30 16:54 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Postgresql and xeon.
  2005-05-30 17:02 UTC  Eric Lauzon <eric.lauzon@abovesecurity.com>
` Re: Postgresql and xeon.
  2005-05-30 17:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [5+ messages in thread]

sequential scan performance
  2005-05-29 13:27 UTC  Michael Engelhart <mengelhart@mac.com>
` Re: sequential scan performance
  2005-05-29 13:47 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: sequential scan performance
  2005-05-29 14:43 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: sequential scan performance
  2005-05-29 19:44 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: sequential scan performance
  2005-05-30 16:33 UTC  Michael Engelhart <mengelhart@mac.com>
` Re: sequential scan performance
  2005-05-30 16:53 UTC  Steve Atkins <steve@blighty.com>
  [6+ messages in thread]

Index not used on join with inherited tables
  2005-05-30 15:54 UTC  Sebastian Böck <sebastianboeck@freenet.de>
` Re: Index not used on join with inherited tables
  2005-05-30 16:21 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Index not used on join with inherited tables
  2005-05-30 16:36 UTC  Sebastian Böck <sebastianboeck@freenet.de>
  [3+ messages in thread]

OID vs overall system performances on high load databases.
  2005-05-27 17:05 UTC  Eric Lauzon <eric.lauzon@abovesecurity.com>
` Re: OID vs overall system performances on high load
  2005-05-28 05:08 UTC  Andrew McMillan <andrew@catalyst.net.nz>
` Re: OID vs overall system performances on high load
  2005-05-28 17:36 UTC  PFC <lists@boutiquenumerique.com>
` OID vs overall system performances on high load
  2005-05-29 20:17 UTC  Eric Lauzon <eric.lauzon@abovesecurity.com>
` Re: OID vs overall system performances on high load
  2005-05-29 21:46 UTC  Andrew McMillan <andrew@catalyst.net.nz>
` Re: OID vs overall system performances on high load
  2005-05-29 21:47 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: OID vs overall system performances on high load
  2005-05-30 04:02 UTC  Neil Conway <neilc@samurai.com>
  [7+ messages in thread]

Redundant indexes?
  2005-05-27 21:28 UTC  Jeffrey Tenny <jeffrey.tenny@comcast.net>
` Re: Redundant indexes?
  2005-05-28 00:09 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-09 15:34 UTC  Neil Conway <neilc@samurai.com>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-09 16:34 UTC  Jim C. Nasby <decibel@decibel.org>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-09 16:38 UTC  Neil Conway <neilc@samurai.com>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-09 16:51 UTC  Jim C. Nasby <decibel@decibel.org>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-10 00:14 UTC  Neil Conway <neilc@samurai.com>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-10 02:20 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-10 04:10 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-10 04:25 UTC  Neil Conway <neilc@samurai.com>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-10 04:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-10 05:29 UTC  Neil Conway <neilc@samurai.com>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-10 06:12 UTC  Greg Stark <gsstark@mit.edu>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-10 13:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-10 15:32 UTC  Jim C. Nasby <decibel@decibel.org>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-10 15:39 UTC  Jim C. Nasby <decibel@decibel.org>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-10 15:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-10 17:26 UTC  Jim C. Nasby <decibel@decibel.org>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-10 17:35 UTC  Greg Stark <gsstark@mit.edu>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-10 18:07 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-10 18:12 UTC  Mischa Sandberg <mischa.sandberg@telus.net>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-10 19:50 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-10 21:35 UTC  Mischa Sandberg <mischa.sandberg@telus.net>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-10 22:46 UTC  Mark Lewis <mark.lewis@mir3.com>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-10 22:56 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-10 23:24 UTC  Mischa Sandberg <mischa.sandberg@telus.net>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-10 23:56 UTC  Greg Stark <gsstark@mit.edu>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-11 00:14 UTC  Mischa Sandberg <mischa.sandberg@telus.net>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-11 01:51 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-11 02:02 UTC  Mischa Sandberg <mischa.sandberg@telus.net>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-11 02:03 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-11 02:05 UTC  Mischa Sandberg <mischa.sandberg@telus.net>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-11 02:14 UTC  Neil Conway <neilc@samurai.com>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-11 02:17 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-11 13:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-11 13:59 UTC  Greg Stark <gsstark@mit.edu>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-11 14:14 UTC  Neil Conway <neilc@samurai.com>
` Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
  2005-05-27 22:07 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
  [36+ messages in thread]

Optimising queries involving unions
  2005-05-26 15:22 UTC  Sam Mason <sam@samason.me.uk>
` Re: Optimising queries involving unions
  2005-05-26 16:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Optimising queries involving unions
  2005-05-26 17:42 UTC  Sam Mason <sam@samason.me.uk>
` Re: Optimising queries involving unions
  2005-05-26 18:02 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Optimising queries involving unions
  2005-05-27 07:40 UTC  Marc Mamin <m.mamin@gmx.net>
  [5+ messages in thread]

Re: [PORTS] Which library has these symbols? -- Eureka
  2005-05-25 18:06 UTC  Mohan, Ross <RMohan@arbinet.com>
` Re: Which library has these symbols? -- Eureka
  2005-05-25 21:30 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: [PORTS] Which library has these symbols? -- Eureka
  2005-05-26 01:40 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  [3+ messages in thread]

Inner join on two OR conditions dont use index
  2005-05-25 20:12 UTC  Jocelyn Turcotte <turcotte.j@gmail.com>
` Re: Inner join on two OR conditions dont use index
  2005-05-25 20:18 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Inner join on two OR conditions dont use index
  2005-05-25 21:22 UTC  Jocelyn Turcotte <turcotte.j@gmail.com>
` Re: Inner join on two OR conditions dont use index
  2005-05-25 21:43 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

test - pls delete and ignore
  2005-05-25 20:36 UTC  Mohan, Ross <RMohan@arbinet.com>

Can anyone explain this: duplicate dbs.
  2005-05-25 02:07 UTC  SpaceBallOne <space_ball_one@hotmail.com>
` Re: Can anyone explain this: duplicate dbs.
  2005-05-25 02:21 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Can anyone explain this: duplicate dbs.
  2005-05-25 02:22 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Can anyone explain this: duplicate dbs.
  2005-05-25 02:39 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Can anyone explain this: duplicate dbs.
  2005-05-25 02:53 UTC  SpaceBallOne <space_ball_one@hotmail.com>
` Re: Can anyone explain this: duplicate dbs.
  2005-05-25 03:00 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Can anyone explain this: duplicate dbs.
  2005-05-25 03:00 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Can anyone explain this: duplicate dbs.
  2005-05-25 03:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Can anyone explain this: duplicate dbs.
  2005-05-25 03:02 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Can anyone explain this: duplicate dbs.
  2005-05-25 03:32 UTC  Bruno Wolff III <bruno@wolff.to>
  [10+ messages in thread]

seqential vs random io
  2005-05-23 20:58 UTC  David Parker <dparker@tazznetworks.com>
` Re: seqential vs random io
  2005-05-23 22:23 UTC  John A Meinel <john@arbash-meinel.com>
` Re: seqential vs random io
  2005-05-23 22:32 UTC  Josh Berkus <josh@agliodbs.com>
` Re: seqential vs random io
  2005-05-23 22:35 UTC  Anjan Dave <adave@vantage.com>
  [4+ messages in thread]

Fwd: Index on table when using DESC clause
  2005-05-23 17:41 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Fwd: Index on table when using DESC clause
  2005-05-23 18:03 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Fwd: Index on table when using DESC clause
  2005-05-23 19:02 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Fwd: Index on table when using DESC clause
  2005-05-23 19:46 UTC  Oleg Bartunov <oleg@sai.msu.su>
` Re: Fwd: Index on table when using DESC clause
  2005-05-23 20:27 UTC  Andrew Lazarus <andrew@pillette.com>
` Re: Fwd: Index on table when using DESC clause
  2005-05-23 21:18 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
  [6+ messages in thread]


[next (older)]

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox